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.