Calculate variation according to filter

[diego1991]

Hi, I'm new to qlik sense and still learning the formulas and how they work,

I need help creating a table where I can show the variation between 2 Totals according to the Max and the Min periods Selected in a Filter.

It would be something like

SUM(TOTAL from MAX(Filtered PERIOD))-SUM(TOTAL from MIN(Filtered PERIOD))

Thanks a lot.

Diego Vélez

[diego1991 · Accepted solution]

I already solved it, just used this:

Sum({<PERIODO={$(=Max(PERIODO))}>} [TOTAL])-Sum({<PERIODO={$(=Min(PERIODO))}>} [TOTAL])

Thanks a lot.