2 Replies Latest reply: Feb 15, 2017 12:50 AM by Rahul Pawar RSS

    Get previous year data from drill-down rows

    Kevin Somosera

      Hi,

      I'm new at Qlik Sense and I'm currently working on the Pivot table. You can check this screenshot for your guide:

      Untitled.jpg

      Required: I need to insert a measures for Prior Year Actual sales

                     I need to find the percentage difference between the first measure(Actual) and the second measure(Prior Year)

       

      Just to make my question clear, how can I have the values from 2015 including the drill-down rows into the 2016 Prior Year column.

       

      EXAMPLE:

                          IN 2016 Prior year Measure = 62688 and so on.

       

      Thanks in advance!