Qlik Community

Qlik Sense App Development

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

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

Highlighted

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