Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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