Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Solution to make a lop expression for rangeavg

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.

0 Replies