Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
ksomosera10
Contributor 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
rahulpawarb
Valued Contributor III

Re: Get previous year data from drill-down rows

2 Replies
Partner
Partner

Re: Get previous year data from drill-down rows

If possible share sample app

rahulpawarb
Valued Contributor III

Re: Get previous year data from drill-down rows