Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Vervoort
New 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

Re: Calculate % and difference in pivot

May be try this

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

Re: Calculate % and difference in pivot

Unfortunately, no... 

Re: Calculate % and difference in pivot

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

Vervoort
New Contributor

Re: Calculate % and difference in pivot

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. 

Re: Calculate % and difference in pivot

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
New Contributor

Re: Calculate % and difference in pivot

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

Re: Calculate % and difference in pivot

Use it as a measure and not dimension 🙂

Vervoort
New Contributor

Re: Calculate % and difference in pivot

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

QS_2.JPG

Re: Calculate % and difference in pivot

Just use minus instead of divide