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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. 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
Champion III
Champion III

Maybe

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

-

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