Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ............................
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)
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
Hi
Michael's expression should work fine in QV10 as well, as far as I can see.
Regards
Jonathan
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.