Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Get previous year data from drill-down rows

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!

1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

2 Replies
Highlighted
Partner
Partner

If possible share sample app

Highlighted
Specialist III
Specialist III