topic Re: Set Analysis Query in QlikView

Set Analysis Query

alknirmal1 — Thu, 25 Jun 2015 19:01:47 GMT

Hi All,

I have one set analysis expression which is given below . its working perfectly fine..

=sum({<[MONTH-NUMERIC] = P({<YEAR={$(vBusinessYear)}>}[MONTH-NUMERIC])>}[NET WRITTEN PREMIUM])

I am trying to calculate '<=' instead of '=' condition in the above expression and I am not able to succeed.

Can somebody please help me to make the expression to calculate lessthan or equal to condition instead of just equal to ?

Thanks in advnace

Nirmal.

Re: Set Analysis Query

sunny_talwar — Thu, 25 Jun 2015 19:07:58 GMT

From what I understand, your expression is summing all Net Written Premium within the business year (which is set in your variable vBusinessYear) for all possible months. Do you still need less than or equal here???

Re: Set Analysis Query

alknirmal1 — Thu, 25 Jun 2015 19:59:24 GMT

Hi,

Thanks for your reply.

I completely understand your point.

But Actually when i select a month value from list box, the result is restricted to that month.. I am looking for the result <= in such scenario.

Regards

Nirmal.

Re: Set Analysis Query

sunny_talwar — Thu, 25 Jun 2015 20:01:37 GMT

Try this:

=Sum({<YEAR={$(vBusinessYear)}, [MONTH-NUMERIC] = {"<= $(=Max({<YEAR={$(vBusinessYear)}>}[MONTH-NUMERIC])")>}[NET WRITTEN PREMIUM])

Re: Set Analysis Query

jagan — Fri, 26 Jun 2015 07:28:30 GMT

Hi,

Try this expression

=Sum({<YEAR={'$(vBusinessYear)'}, [MONTH-NUMERIC] = {'<= $(=Max([MONTH-NUMERIC]))'} >}[NET WRITTEN PREMIUM])

Hope this helps you.

Regards,

Jagan.

Re: Set Analysis Query

alknirmal1 — Fri, 26 Jun 2015 13:36:03 GMT

Thanks to Jagan and sunindia..Both the expression are working correctly ..

Re: Set Analysis Query

sunny_talwar — Fri, 26 Jun 2015 13:42:00 GMT

Great, we are glad that we were able to help.

I suggest marking one of the answers as correct (and may be other one as helpful) to close the thread.

Best,

Sunny