Multiple Expression vs Multiple Dimension

[d44973694]

Hi,

What would yield a better performance in charts in Qlik - Multiple Expression with 1 dimension? or One expression with multiple dimension

For instance, if I have 2 dimension Time, and Product. And Expression Sum(Units).

Which would be faster?

a) 2 dimension - Time and Product

     Expression - SUm(Units)

b) Dimension - Time

      Expressions - Sum({<Product={'A'}>}Units),

                              Sum({<Product={'B'}>}Units)

considering this being a huge amount of data and having 7-8 products.

[techvarun]

2 Dimension and one expression is faster in this case.

The second case has to perform two set operations and in the first case there is only one Sum() function so the option one is faster.

Just in case we have two calculated dimension and one expression,we have to rethink.

[techvarun]

One more way to test is we can create two charts with both the cases and check the CalcTime  and memory used through sheet properties