Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation Performance

May be an interesting debate, I have just took over a QV dashboard and from looking at the calcs it has raised this question in my head.

One of the calcs,

sum(if([Year]='2016'and [Week]='1',[Age]))

I would have written as

Sum({$<Year={$(=2016)},Week={$(=1)}>}Age)

Which version of the calc would you say is the best for the overall performance of the dashboard? and to expand my knowledge why?

1 Reply
sunny_talwar

I would use set analysis, but with slight changes

Sum({<Year = {2016}, Week = {1}>} Age)

This because set analysis is evaluated once per chart and should lead to some better performance