1 Reply Latest reply: Jun 28, 2018 3:17 PM by Diego Alejandro Velez Becerra RSS

    Calculate variation according to filter

    Diego Alejandro Velez Becerra

      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