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

    Get previous year data from drill-down rows

    Kevin Somosera


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


      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.



                          IN 2016 Prior year Measure = 62688 and so on.


      Thanks in advance!