Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Pivot table: Difference between two columns Qlik Sense

Hello,

im new in Qlik Sense. I have a question: How i can get the difference between two columns?

e.g:

And how can i get the difference between two selected years? e.g.  Select 1: 2012 and 2014 : Select 2: 2015 and 2014

Thank you

Regards

Mustafa

4 Replies

Re: Pivot table: Difference between two columns Qlik Sense

sum([CE11000.InvoiceSales]) - before(sum([CE11000.InvoiceSales]))


talk is cheap, supply exceeds demand
Not applicable

Re: Pivot table: Difference between two columns Qlik Sense

Hello Gysbert,

im new in Qlik Sense. Can you tell me where i have to add this formula exactly?

Re: Pivot table: Difference between two columns Qlik Sense

As a measure in your pivot table. If you want to use a KPI object then use this expression:

sum({<Calendar.Year={$(=max(Calendar.Year))}>}[CE11000.InvoiceSales]) - sum({<Calendar.Year={$(=min(Calendar.Year))}>}[CE11000.InvoiceSales])


talk is cheap, supply exceeds demand
Not applicable

Re: Pivot table: Difference between two columns Qlik Sense

Thank you Gysbert. Your answer was helpful

Community Browser