Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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])