Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kcville
Contributor II
Contributor II

Create a measure in pivot table that compares the field value of two dimensions

Hello

I have a pivot table with Department rows and columns of Years. 

I have a measure of Sum of Sales, how do I create a new measure that gives me the % increase from the Sum of Sales 2018 to Sum of Sales 2019.

I tried to use Set Analysis, e.g. if I create a measure like this...

Sum(${<Year={'2018'}>}Sales))

What I want to see from that expression was the Sum of Sales for 2018 in each Dimension/Year (this is just a test as I know I want % increase), but I just get zeros and only results for dimension for 2018.  Ie I want to be able to reference the results from the previous year.

Help would be appreciated as I have spent far too long on this now.

Thank you 🙂

Labels (2)
1 Reply
jyothish8807
Master II
Master II

Hi Kcville,

You can simply try this:

((Sum(${<Year={'2019'}>}Sales)) - Sum(${<Year={'2018'}>}Sales))) / Sum(${<Year={'2018'}>}Sales)) ) *100

Note: You can create variable for hard coded years to make it dynamic.

Br,

KC

Best Regards,
KC