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: 
Vervoort
Contributor
Contributor

Calculate % and difference in pivot

Dear all,

Please find below a screenshot of the pivot i've got. I want to calculate the difference between 2018 and 2019 in absolute numbers and the in-/decrease of 2019 compared to 2018. 

 

QS_Pivot.JPG

9 Replies
sunny_talwar

May be try this

Sum(Measure)/Before(Sum(Measure))
Vervoort
Contributor
Contributor
Author

Unfortunately, no... 

sunny_talwar

What was wrong when you used it? Would you be able to provide more information on where you want to see this?

Vervoort
Contributor
Contributor
Author

Absolute difference, as a column after 2019.

So for line 1 BOM Mass Change it's 108-27=81 more increase.

And after the absolute number a column with % of the 81 difference/increase. 

sunny_talwar

Try this for Absolute Difference

Sum(Measure)-Before(Sum(Measure))

Not sure what you mean here?

"And after the absolute number a column with % of the 81 difference/increase. "

What is the difference between difference and increase?

Vervoort
Contributor
Contributor
Author

It says, invalid dimension
=Sum(Subcategorie)/Before(Sum(Subcategorie))
sunny_talwar

Use it as a measure and not dimension 🙂

Vervoort
Contributor
Contributor
Author

almost there I think, only the outcome doesn't make sense

QS_2.JPG

sunny_talwar

Just use minus instead of divide