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:



      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:




      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!