6 Replies Latest reply: Jan 12, 2018 5:25 AM by murali y RSS

    pulling previous years data while current year selected

    murali y

      Hi,

      I have data in below format in a table.

       

      YearMonthMeasure
      201501385
      201502452
      201503652
      201601584
      201602548
      201603500
      201701545
      201702485
      201703458

      I'm looking to show difference of the values by year in tabular format as shown in the below table, when the user selects year from filter then the table in Qlik Sense should show difference between selected year and previous year as shown in below table.

       

      MonthCurrentyearvalueprevious year valuDifferencevalue
      Jan545584-39
      Feb485548-63

       

      I tried different ways including set analysis, but the previous year values are not getting picked. Appreciate any help.

       

      Thanks