# Qlik Sense App Development

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Did you mean:
Highlighted
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.

9 Replies
Highlighted
MVP

## Re: Calculate % and difference in pivot

May be try this

``Sum(Measure)/Before(Sum(Measure))``
Highlighted
Contributor

## Re: Calculate % and difference in pivot

Unfortunately, no...

Highlighted
MVP

## 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?

Highlighted
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.

Highlighted
MVP

## 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?

Highlighted
Contributor

## Re: Calculate % and difference in pivot

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

## Re: Calculate % and difference in pivot

Use it as a measure and not dimension 🙂

Highlighted
Contributor

## Re: Calculate % and difference in pivot

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

Highlighted
MVP

## Re: Calculate % and difference in pivot

Just use minus instead of divide