4 Replies Latest reply: May 30, 2012 11:57 PM by Michael Fenton RSS

    Set Analysis

      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

          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)