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

    Previous month Calculations with Set analysis in QlikSense

    Naresh M

      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