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;