Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
diego1991
Contributor III
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
Contributor III
Contributor III
Author

I already solved it, just used this:

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

Thanks a lot.

View solution in original post

1 Reply
diego1991
Contributor III
Contributor III
Author

I already solved it, just used this:

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

Thanks a lot.