Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

diego1991
New Contributor III

Calculate variation according to filter

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

1 Solution

Accepted Solutions
diego1991
New Contributor III

Re: Calculate variation according to filter

I already solved it, just used this:

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

Thanks a lot.

1 Reply
diego1991
New Contributor III

Re: Calculate variation according to filter

I already solved it, just used this:

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

Thanks a lot.