Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sebastian_marti
Contributor II
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_dimperio
Specialist II
Specialist II

May you show me your Totales cod, pls?

sebastian_marti
Contributor II
Contributor II
Author

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

SALDO = Amount of account

Cuentas_EERR = Account Clasification

eduardo_dimperio
Specialist II
Specialist II

Maybe,

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