This content has been marked as final. Show 3 replies
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!