topic Re: put a condition in set analysis as variable in QlikView

put a condition in set analysis as variable

ali_hijazi — Mon, 10 Nov 2014 14:25:41 GMT

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 — Mon, 10 Nov 2014 14:29:33 GMT

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 — Mon, 10 Nov 2014 16:16:13 GMT

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 — Mon, 10 Nov 2014 16:17:52 GMT

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

ali_hijazi — Tue, 11 Nov 2014 07:42:30 GMT

yes it works

thank you very much indeed