Qlik Community

Qlik Sense App Development

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

sebastian_marti
New Contributor II

Qliksense: Difference between two column years Pivot Table

I got this problem. I made a difference between two years but i want to show the measure in the end of the table.

I need this solution: (paint)

Please help me!

3 Replies
eduardo_dimperi
Valued Contributor II

Re: Qliksense: Difference between two column years Pivot Table

May you show me your Totales cod, pls?

sebastian_marti
New Contributor II

Re: Qliksense: Difference between two column years Pivot Table

=Sum ( {<[Cuentas_EERR]= {1}>}  [SALDO])

SALDO = Amount of account

Cuentas_EERR = Account Clasification

eduardo_dimperi
Valued Contributor II

Re: Qliksense: Difference between two column years Pivot Table

Maybe,

Sum ( {<[Cuentas_EERR]= {1}, [YEAR]={'2018'}>}  [SALDO])  - Sum ( {<[Cuentas_EERR]= {1},[YEAR]={'2017'}>}  [SALDO])

Community Browser