3 Replies Latest reply: Nov 17, 2015 1:10 PM by Alfonso Vicuna RSS

    How to use Total in a if sentense in QLIK SENSE

      hi, im new to qlik sense and i have been searching for a way to do the following:

       

      i have the following table:

      Capture.JPG

       

      and i need to calculate the return of those values, so i defined a variable with the first date

       

      vFecha_Inicial = minstring(fecha)

       

      and at the table i used the following code:

       

      sum(TOTAL <valor_cuota> if( fecha  = vFecha_Inicial,aggr(sum(valor_cuota), fecha, fondo_id )))- 1

       

      but it gives me:

       

      Capture.JPG

       

      which is the sum of the two rows. how do i get the values without using sum? so in every date i have the values of the first date?

       

      any help is greatly appreciated. thanks!