Avg Positive Values in Simple Table

CarlosCan — Mon, 05 Dec 2022 16:29:04 GMT

Hi Community good morning,

I have a simple table which shows negative and positive values.

How can I get the average of the positive values, excluding negative or zero values?

the expected value in the sum of the table should be 0.18 not 0.78, not 0.09.

My Expression is:

if(

(num(IF(Avg(Aggr(AVG({<Actividad={"CheckIn"},TipoCheck={"Llegada a tienda"}>}HoraRegistroN-HoraFinEN),TIENDA,DÍA_MES))< 0 ,-1, 1)*
((Div(fabs(Avg(Aggr(AVG({<Actividad={"CheckIn"},TipoCheck={"Llegada a tienda"}>} HoraRegistroN-HoraFinEN),TIENDA,DÍA_MES))),1))
+ (Frac(fabs(Avg(Aggr(AVG({<Actividad={"CheckIn"},TipoCheck={"Llegada a tienda"}>} HoraRegistroN-HoraFinEN),TIENDA,DÍA_MES))))* 0.6)),'0.00'))>0,

num(IF(Avg(Aggr(AVG({<Actividad={"CheckIn"},TipoCheck={"Llegada a tienda"}>}HoraRegistroN-HoraFinEN),TIENDA,DÍA_MES))< 0 ,-1, 1)*
((Div(fabs(Avg(Aggr(AVG({<Actividad={"CheckIn"},TipoCheck={"Llegada a tienda"}>} HoraRegistroN-HoraFinEN),TIENDA,DÍA_MES))),1))
+ (Frac(fabs(Avg(Aggr(AVG({<Actividad={"CheckIn"},TipoCheck={"Llegada a tienda"}>} HoraRegistroN-HoraFinEN),TIENDA,DÍA_MES))))* 0.6)),'0.00'),0)

Thanks for your support!!!

Regards.

topic Avg Positive Values in Simple Table in QlikView

Avg Positive Values in Simple Table