Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
karla_gonzalez
Partner - Contributor II
Partner - Contributor II

Sum of two years difference

Hello,
I have to subtract an amount for the current year vs. the previous year:
I already try these formulas but I have not succeeded.


Sum({<Ejercicio += {{$(=Max(Ejercicio))}>}, {$(=Max(Ejercicio)-1)>}}>} Saldo)


Where Ejercicio is 2017 y 2018 example.


1 Reply
swuehl
MVP
MVP

Maybe

=Sum({<Ejercicio = {$(=Max(Ejercicio))} >}  Saldo)

-

Sum({<Ejercicio = {$(=Max(Ejercicio)-1) >} Saldo)