7 Replies Latest reply: Sep 20, 2017 2:10 PM by qlik tech RSS

    Last 12 months

    qlik tech

      Hi,

       

      I have extracted the data for the last 12 months and now need to do month on month analysis.

       

      If a user selects lets say May 2017, I need to show the data for May and difference from April, ie May - April.

       

      So do I use GetFieldSelections and then use Addmonths(month, -1)?

       

      In another table I need to show a trend as well, so to sort the data from last month to the current month, how would I sort it?

       

      thanks.