topic Set Analysis in QlikView

Set Analysis

Tue, 29 May 2012 04:16:52 GMT

Why my below expression s not working???

Sum({<DataFlag = {'Plan'},

CalendarMonth = {"<=$(=Max(CalendarMonth))"},

CalendarMonth = {"$(=GetSelectedCount(CalendarMonth))>=1"}

>}Data)

I am getting the output 0 , even when i select the month.

Please help ............................

Set Analysis

Tue, 29 May 2012 06:14:43 GMT

What are you trying to achieve with this part?

CalendarMonth = {"$(=GetSelectedCount(CalendarMonth))>=1"}

If you are trying to only calculate the expression if 1 or more months are selected, then it should go in the Calculation Condition of your chart, or the Conditional box within the Expressions tab.

If you are using a version of QlikView prior to 11, then you will probably have to wrap your set expression in an If statement like this:

If(GetSelectedCount(CalendarMonth))>=1

Sum({<DataFlag = {'Plan'},

CalendarMonth = {"<=$(=Max(CalendarMonth))"}

>}Data)

Set Analysis

Tue, 29 May 2012 06:45:14 GMT

Hi Michael

Thanks for your reply but i want that if conditon to be included my set expression .

Is that possible...i am using qlikview 10

Re: Set Analysis

jonathandienst — Tue, 29 May 2012 07:34:53 GMT

Michael's expression should work fine in QV10 as well, as far as I can see.

Regards

Jonathan

Set Analysis

Thu, 31 May 2012 03:57:08 GMT

Is there any reason that you want the condition inside the set exression? Is it part of a more complex expression?

From my understanding of your requirement, putting an "If" around the Sum is more efficient and easier to read.