Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Year is one of my dimensions.
I cannot get the year in the set analysis expression.
For the time being I have solved it this way:
if(Year=2018,sum(amount) * max({$ <[date-cur] = {'31-12-2018'}>} rate),
if(Year=2017,sum(amount) * max({$ <[date-cur] = {'31-12-2017'}>} rate),
if(Year=2016,sum(amount) * max({$ <[date-cur] = {'31-12-2016'}>} rate)
I am sure there must be a more efficient way.
Who can help ?
Below is Design Blog post on Set Analysis, and there are 4 other links at the bottom of the post pointing to other related posts that may be of some help here.
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
If you want to search the Design Blog area yourself, here is the base URL:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett