StDev funtion for script

[olgaavalos]

Hi,

Apply this formula in Qlik with this expresion and it is working very well:

StDev(
Aggr(
Sum({<Fecha_Liquidez={">=$(=Date(Min(Fecha_Liquidez)+30,'D/M/YYYY'))"}>}Variaciones),
Cod_Cuenta_liq,Fecha_Liquidez
)
)

But I need to apply this into the script but it is not working. Please help me!!

The script is:

Matriz_LiquidezI:
Load Cod_Cuenta_liq,
Fecha_Liquidez,
if(sum(Saldo_Liquidez)=0 and sum(Saldo_LiquidezII)=0,0,
if(sum(Saldo_Liquidez)=0 and sum(Saldo_LiquidezII)>0,log(2),
if(sum(Saldo_Liquidez)>0 and sum(Saldo_LiquidezII)=0,-log(2),log(sum(Saldo_LiquidezII)/sum(Saldo_Liquidez)))))
as Variaciones
Resident Liquidez
Group by Cod_Cuenta_liq,Fecha_Liquidez
;

NoConcatenate
Desviacion_Estandar:
Load
Cod_Cuenta_liq,
Fecha_Liquidez,
StDev(Variaciones) as Desviacion_Estandar
Resident Matriz_LiquidezI
Group by Cod_Cuenta_liq,Fecha_Liquidez
;