Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Multiple Expression vs Multiple Dimension

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 Replies
Highlighted
Specialist II
Specialist II

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.

Highlighted
Specialist II
Specialist II

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

sample.PNG