Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
lse
Employee
Employee

Quick Tips #6 - Expressions, comparisons

While we're on the topic of Expression Overview.

Do a quick search thru your expressions and count the number of comparisons made. Both if's and set-analysis.

QlikView compares numbers faster than text. Comparing sum(if(fieldA='1', fieldB)) to sum(if(fieldA=1, fieldB)), the later will be faster. Same goes for set-analysis sum({$<FieldA={1}>} fieldB) is faster than sum({$<FieldA={'1'}>} fieldB).

From a UI-calculation perspective it's a good idea to create fields at reload time with flags and numeric values for comparisons.

UI-optimization is all about shaving off cpu-cycles used to calculate and present the objects.

Cheers from the Scalability Team.

Labels (1)
0 Replies