9 Replies Latest reply: Oct 3, 2017 8:38 PM by Fabiana Iglesias RSS

    Totals in a table as a KPI

    Fabiana Iglesias

      Hi everybody,

       

      I've beeing reading lot of posts to find an answer to my doubt but I can´t reach the right one, so I decided to make a post.

       

      I have this table:

       

      Where:

       

      Venta Mensual actual = Sum(IF(IDCuentaContable=40, Monto))

      Venta mensual Anterior = Sum(IF(IDCuentaContable=40, MontoAnterior))

      Evolucion ventas = Sum(IF(IDCuentaContable=40, Monto))/Sum(IF(IDCuentaContable=40, MontoAnterior))/100

       

      All of them are master elements.

      I need to filter only account No 40.

      Monto Anterior was created from script as follow:

       

        IF(((Mes-1)=0),0, (Previous(Monto))) as MontoAnterior

       

      I want to show the Total of Evolucion Ventas (1.49%) as a KPI

      I've tried with a lot of functions but I can´t do it.

       

       

      Could I have some help? I´m making my first steps with Qlik Sense