topic Re: Set Analysis question in QlikView

Set Analysis question

dennysetiawan — Wed, 25 Nov 2020 16:16:04 GMT

Hi community,

I have an expression with set analysis like this:

sum({<[BRAND]={"=RANK(SUM({<[SALES]-={0}>}-[SALES]),4)<=10"}>}[SALES])

Then I want to put this analysis on that expression:

MONTHYEAR={'$(vMTD)'}

where vMTD =DATE(ADDMONTHS(NOW(),-1),'MMM-YYYY')

Can anyone help me what is the correct script of set analysis to cover the two expressions above?

Thank you

Re: Set Analysis question

sushil353 — Tue, 12 Jul 2016 08:34:37 GMT

Try:

sum({<[BRAND]={"=RANK(SUM({<[SALES]-={0}>}-[SALES]),4)<=10"},MONTHYEAR={'$(vMTD)'}>}[SALES])

Re: Set Analysis question

sunny_talwar — Tue, 12 Jul 2016 10:15:05 GMT

May be one of these:

Sum({<[BRAND] = {"=Rank(Sum({<[SALES]-={0}>}-[SALES]), 4) <= 10"}, MONTHYEAR={'$(vMTD)'}>}[SALES])

Sum({<[BRAND] = {"=Rank(Sum({<[SALES]-={0}, MONTHYEAR={'$(vMTD)'}>}-[SALES]), 4) <= 10"}, MONTHYEAR={'$(vMTD)'}>}[SALES])

Sum({<[BRAND] = {"=Rank(Sum({<[SALES]-={0}, MONTHYEAR={'$(vMTD)'}>}-[SALES]), 4) <= 10"}>}[SALES])

Re: Set Analysis question

susovan — Tue, 12 Jul 2016 10:25:27 GMT

Try this expression,

sum({<[BRAND]={"=RANK(SUM({<[SALES]-={0}>}-[SALES]),4)<=10",MONTHYEAR={"=$(vMTD)"}>}[SALES])

Re: Set Analysis question

dennysetiawan — Tue, 12 Jul 2016 10:52:17 GMT

Thank you Sunny.

The best answer is Sum({<[BRAND] = {"=Rank(Sum({<[SALES]-={0}, MONTHYEAR={'$(vMTD)'}>}-[SALES]), 4) <= 10"},MONTHYEAR={'$(vMTD)'}>}[SALES])