Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try using the first() function to grab the left most 'fecha'
The percent growth from the first month is:
sum(Sales) / first( Sum(Sales))
Can you post a sample app or data?
However, you may try if(fecha = $(vFecha_Inicial) instead.
Try using the first() function to grab the left most 'fecha'
The percent growth from the first month is:
sum(Sales) / first( Sum(Sales))
that was extactly what i was searching for!, thank you!! a lot!!