Dimension in set analysis

[hansrokers]

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 ?

[dplr-rn]

i am assuming the year is not related to date-cur.
if not maybe you can try associating them.

[Brett_Bleess]

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