26 Replies Latest reply: May 13, 2016 7:44 AM by Umamaheswara Reddy RSS

    Max(Month) not working in Set Analysis

    Umamaheswara Reddy

      Hi All

      I am facing Set Analysis issue in Qlikview 11.2 v


      The issue is

      I have to show the total sum in the set expression for the last month from date



      Eg: I have data for some days ( the dates may be from Jan, Feb, Mar), i have to display the data based last month. As of now we got 3 months data in future there may be a chance to increase. I used static value in set expression like below, it worked, but when I place dynamic expression it's not work.


      The below one works

      Static: sum({<Month={"Mar"}>}sales)



      The below one not working

      Dynamic :

      sum({<Month={$(=Max(Month))}>}sales)


      Can any one help me to solve this