Discussion board where members can get started with Qlik Sense.
I would like to use variable which stores rank function in set analysis.
This is the variable which I want to use in Set Analysis:
where vABC keeps the Pick function with some variables.
This is the whole formula:
and it doesn't work.
When I put in the table dim1 and $(vVariable1) it shows data correctly.
Do you have any idea what's wrong?
Go to Solution.
I found the solution.
If someone is interested you should define variable like this:
set Variable1 = rank(fabs($(vABC)),4,2))=1
and then use it in the measure this way: