- GetCurrentField() - will return the current field in the Group.
- ValueList and ValueLoop() - They are used for creating synthetic dimensions on the fly, Refer Qlivkiew help file for syntax and example
Optimize Qlikview application:
The major areas in Optimizing Dashboard is
Good Data Model
Expressions (Try to avoid Aggr, Calculated Dimensions, etc)
Limited Calculations in Expressions
Don't display huge data in Straight, Pivot and Table boxes (Restrict user to select filters to reduce data to be displayed in table)
Qlikview file size (Load only dimensions and data which are used in Dashboard)
Check below link
How to get current selection in the Drill down /cyclic group field?
How to optimize qlikview Application?
Optimising Qlikview means increase the speed of the application for any selection did by client in access point and also increase the speed of the application reloading for scheduled time i.e decrease the time of loading.
1)you need to remove unnecessary columns from Edit script(delete unnecessary columns,drop unnecessary tables)
2) Reduce joins to less number
3)Remove synthetic keys,Tables and also remove circular loops
4)Load data using qvd's
5)if possible reduce the set analysis expressions in front end and do it those in script level.
what is valuelist and valueloop functions?
1.synthetic dimension functions (valuelist &value loop).
2. dimension wise it 'll display tthe values.
syn: valuelist('1','5') it'll display the only 1&5 values
valueloo('1','5') it'll display the all( 1,2,3,4,5 values)