3 Replies Latest reply: Nov 20, 2016 12:43 PM by Naresh M RSS

    Previous month Calculations with Set analysis in QlikSense

      Hi Everyone,


      Can any one help me on this topic...,


      I have a data like below,


      Year, MonthName, Sales

      2016, Jan, 1000

      2015,Dec, 570

      2016, Feb, 300


      Based on the above example, I have a filters called YEAR, MONTH, If i select JAN Month and 2016 year,  i want to see the Dec 2015(Previous month) Sales, Can you please help me how i need to write set analysis for this...


      If possible kindly send me the QlikSense file