topic Dimension in set analysis in QlikView

Dimension in set analysis

hansrokers — Fri, 11 Oct 2019 12:03:05 GMT

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 ?

Re: Dimension in set analysis

dplr-rn — Fri, 11 Oct 2019 18:06:35 GMT

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

Re: Dimension in set analysis

Brett_Bleess — Wed, 16 Oct 2019 15:07:53 GMT

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