5 Replies Latest reply: Jan 31, 2014 12:39 PM by Santharubban Kumarasamy Shanmugasundaram RSS

    As on Date

    SIVASUBRAMANIAN KNK

      Hi all,

      I am new to qlikview.

       

      I want to build a expression by following condition

       

      For example, I have number of items and i want to see the sales of that items.

      If i click Year as 2013 and month as Jun , it should show me the sales from 2013 Jan to Jun.

      Similarly , if i click Year as 2013 and month as Nov, it should show me the sales from 2013 Jan to Nov.

      My expression doesnt satisfy the above condition.

      I have set variable vcurrentyear=Max(Year) and vmonth= Max(Month)

      and my expression is Sum(if(Year=vcurrentyear and Month=vmonth,SalesAmount)).

       

      Please help me in solving this issue.

       

      Regards,

      Sivasu