topic Re: set analysis related query in QlikView

set analysis related query

Fri, 13 Feb 2015 08:42:02 GMT

Dear Team,

i am using a variable to get over all Daily Trade Value average in Cr. below is my equation/syntax of Set Analysis

=(sum({1}TRADE_VALUE)/ sum({1} TRADING_DAYS)/10000000)

Above mention query is working fine. its excluding all the selection and giving me result.

Now my requirement is i want same set of information ( Exclude all selection) but Daily Trade Value Average will be for Max Month.

=(sum({1} {<MONTHYEAR={'$(vMaxMonthYear)'}>} TRADE_VALUE)/sum({1} {<MONTHYEAR={'$(vMaxMonthYear)'}>} TRADING_DAYS) )/10000000

Above is the query which i have written but it is not working fine when i select any other dimension other that MONTHYEAR. Kindly help

Thanks & Regards,

JKV

Anonymous — Fri, 13 Feb 2015 08:47:28 GMT

Hi,

you can try with

sum({1} {<MONTHYEAR=p({< MONTHYEAR={'$(vMaxMonthYear)'}>} MONTHYEAR) >} TRADE_VALUE)

and the same for the second sum

BR,

Elena

Fri, 13 Feb 2015 09:02:21 GMT

No This is not working when i am selecting Member_name dimension this showing result of max month of that particular member_name only

Anonymous — Fri, 13 Feb 2015 09:06:40 GMT

Maybe, in the definition of your variable, you have to insert {1} to exclude all selections.

AbhijitBansode — Fri, 13 Feb 2015 09:10:55 GMT

Can you try below:

=(sum({1<MONTHYEAR={'$(vMaxMonthYear)'}>}TRADE_VALUE)/ sum({1<MONTHYEAR={'$(vMaxMonthYear)'}>} TRADING_DAYS)/10000000)

Fri, 13 Feb 2015 09:14:20 GMT

Thanks .. Abhijit

Fri, 13 Feb 2015 09:14:45 GMT

Thanks Elena for your Help

AbhijitBansode — Fri, 13 Feb 2015 09:16:21 GMT

anytime