put a condition in set analysis as variable

[ali_hijazi]

Hello got the following condition which I use in set analysis    

TPK={"=RANK(COUNT(RECORD_ID))<=$(vTopXTPK)"}

this condition I want to use it in several expressions on more than one chart

I want to put it in a variable and use this variable in set analysis

please advise on what would be the syntax if I put the above condition in variable for the following expression

COUNT(DISTINCT {<TPK={"=RANK(COUNT(RECORD_ID))<=$(vTopXTPK)"}, IS_WASTE={1}>} RECORD_ID) 

[MK_QSL · Accepted solution]

Create a variable as below

var1

RANK(COUNT(RECORD_ID))<=$(vTopXTPK)

Now use in expression as

COUNT(DISTINCT {<TPK={"=$(var1)"}, IS_WASTE={1}>} RECORD_ID)

[ali_hijazi]

can I put in var1 2 definitions based on another variable?

will it work?

i.e. if ($(var1)= 1, rank(count(record_id)) <=$(vTopXTPK),Rank(Count(distinct {< some_set_analysis_here>} Record_ID))

[MK_QSL]

Not sure... need to work on your data or apps.. .Try it...

[ali_hijazi]

yes it works

thank you very much indeed