6 Replies Latest reply: Jul 27, 2016 1:52 PM by Avinash R RSS

    Need some logic/formula to apply in Qlikview NPrinting

    Vinu Priya

      I need to add current month values and i used the formula month(now()) in filter in NSQ file. I want to add YTD data(from May 2016 to May 2017). How I can create a filter which will display the values of YTD and each and every month it needs to be added with the current month data from May 2016.

       

      If I use month(now())-1 then it will display only the current month and the previous month data. Can you please help me to derive some logic for the same in NPrinting Filter.