2 Replies Latest reply: Mar 26, 2012 12:55 AM by jagan mohan rao appala RSS

    Set Analysis

      Sum({$<Year = {2005 },Month = {jan,Feb }>} Sales)

       

       

      Is the above expression is a valid expression ???????????????

        • Set Analysis
          Celambarasan Adhimulam

          Hi,

               There is no problem for numbers.

               For literals you have to use single quotes

          Check with it.

          Sum({$<Year = {2005},Month = {'Jan','Feb'}>} Sales)

           

          Celambarasan

          • Set Analysis
            jagan mohan rao appala

            Hi,

             

            It is not mandatory to use Single quotes for strings in set analysis expressions.  But it is good practice to use Single quotes.

             

            =Sum({$<Year = {2005 },Month = {'Jan','Feb' }>} Sales)

             

            Note : Also qlikview is case sensitive, you used jan, Feb in two different casings, I think it should be Jan, Feb.  Your expression should be

             

            =Sum({$<Year = {2005 },Month = {'Jan','Feb' }>} Sales)

            or

            =Sum({$<Year = {2005 },Month = {Jan,Feb}>} Sales)

             

            Hope this helps you.

             

            Regards,

            Jagan.