Reference a dimension value in set analysis

danielact — Tue, 18 Dec 2012 18:27:27 GMT

I want to pull specific ranks from an aggregation of values. Currently, I'm using this expression:

sum({$<IDKey={"=aggr(nodistinct rank(Sum(Losses),4,1),Year)=1"}>}Our_Loss)

5 times, with different equals values (let's say =1, =2, =3, =4, and =5).

If I set a dimension with values 1, 2, 3, 4, 5, is there a way to reference the dimension in the expression? I created a new table with the values, called NumList, and tried this:

sum({$<IDKey={"=aggr(nodistinct rank(Sum(Losses),4,1),NumList,Year)=NumList"}>}Our_Loss)

but it didn't work.

Any ideas on how to do this?

Re: Reference a dimension value in set analysis

vgutkovsky — Tue, 18 Dec 2012 21:06:59 GMT

This is not possible with set analysis, which is calculated once for the entire chart and does not take dimensions into accounts. To conduct a check on dimensions, you will need to use straight conditional logic (IF or PICK or something).

Regards,

Vlad

topic Re: Reference a dimension value in set analysis in QlikView

Reference a dimension value in set analysis

Re: Reference a dimension value in set analysis