QlikView初级培训教程-脚本使用

QlikView初级培训教程-脚本使用

QlikView脚本使用

1 脚本布局和语句...........................................................................................................................2

1.1 脚本结构............................................................................................................................2 1.2 数据加载语句....................................................................................................................2 1.3 脚本关键字及语句............................................................................................................2 2 . 命名和变量................................................................................................................................3

2.1 表和字段命名....................................................................................................................3 2.2 逻辑表命名........................................................................................................................7 2.3 变量应用............................................................................................................................8 3 . 运算与函数................................................................................................................................8

3.1 运算操作............................................................................................................................8 3.2 函数应用............................................................................................................................9 4 . 逻辑表连接................................................................................................................................9

4.1 join的应用.........................................................................................................................9 4.2 concatenate应用...............................................................................................................10 5 . 数据清洗..................................................................................................................................11

5.1 条件语句..........................................................................................................................11 5.2 Mapping用法介绍...........................................................................................................12 6 . 数据加载..................................................................................................................................13

6.1 QVD文件使用.................................................................................................................13 6.2 增量方式..........................................................................................................................14 6.3 四种典型情况..................................................................................................................14 7 . 访问控制..................................................................................................................................15

7.1 访问级别控制..................................................................................................................15 7.2 动态数据缩减..................................................................................................................17

第1页下一页