Learning Objectives: In this module, you will learn the need and different features of scripting. You will learn about script toolbar, adding/editing tabs, variables, fields, joins and keep.
- Need of Scripting
- What is Scripting?
- Script Toolbar
- Script Menu Commands
- QlikView Variables (Set,Let) and Fields
- Creating tabs in the script
- Adding Sheet Objects
- Inline table
- Function in QlikView (Sum, Avg, Count, Date, etc)
- Joins: Inner, Left, Right and Outer
- Understanding Keep command
- Edit Script
- QlikView Operations: Concatenate, If statement
- Create variables, Inline load, Functions and Joins