Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I already solved it, just used this:
Sum({<PERIODO={$(=Max(PERIODO))}>} [TOTAL])-Sum({<PERIODO={$(=Min(PERIODO))}>} [TOTAL])
Thanks a lot.
I already solved it, just used this:
Sum({<PERIODO={$(=Max(PERIODO))}>} [TOTAL])-Sum({<PERIODO={$(=Min(PERIODO))}>} [TOTAL])
Thanks a lot.