1 Reply Latest reply: Jun 14, 2018 1:08 PM by Leonardo Contezini RSS

    How to get Selected Month and previous 11 months data in QlikSense

    Praveen Gawande

      Hi All,

      I have data like:

      Calendar MonthSales Value
      CM200001240
      CM200002300
      CM200003100
      CM200004678
      CM200005345
      CM200006789
      CM200007256
      CM200008789
      CM200009310
      CM200010560
      CM200011500
      CM200012546
      CM200101789
      CM200102222
      CM200103333
      .....so on

       

      Wanted to show : Sales Trend Last Twelve Months .

      I would like to have a chart where in user click on calendar month filter (for example CM200101), and qliksense display chart should have CM200101 sales value along with previous 11 months value.

       

      Thanks,

      Praveen.