Solution to make a lop expression for rangeavg

Anonymous — Mon, 27 Jul 2009 15:55:03 GMT

Hello,

is it possible to find a solution to make to do a rangeavg loke this :

=rangeavg(
sum({<ABR_MAGASIN={"DJ"} >} if (QUANTITE <> 0,QUANTITE )),
sum({<ABR_MAGASIN={"DU"} >} if (QUANTITE <> 0,QUANTITE )),
sum({<ABR_MAGASIN={"DL"} >} if (QUANTITE <> 0,QUANTITE )),
sum({<ABR_MAGASIN={"LU"} >} if (QUANTITE <> 0,QUANTITE )),
sum({<ABR_MAGASIN={"SO"} >} if (QUANTITE <> 0,QUANTITE ))
)

ABR_MAGASIN it's market for me and i want to find the avg of quantite per market place.

Thanks for your help.

topic Solution to make a lop expression for rangeavg in QlikView

Solution to make a lop expression for rangeavg