QLIKVIEW基础设置及初步了解

改变语言环境

 开发工具条勾选出来

创建selection box

创建search box

编辑脚本

重加载数据

基本联动思路：table view

 tableview

load FSUPPLIERID as FSUPPLIERID,fje as fje;

SELECT a.FSUPPLIERID FSUPPLIERID,b.FQTY*c.FTAXPRICE fje

FROM dbo.T_PUR_POORDER a

INNER JOIN dbo.T_PUR_POORDERENTRY b ON a.FID = b.FID

INNER JOIN dbo.T_PUR_POORDERENTRY_F c ON b.FENTRYID = c.FENTRYID;

LOAD FSUPPLIERID as FSUPPLIERID,fname as fname;

SELECT FSUPPLIERID,FNAME fname FROM dbo.T_BD_SUPPLIER_l;