Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sophie_irp
Contributor
Contributor

Count something only on max value

Hello,

 

i want to count something on max value for to dimension, i have wrote a set analysis but doesn't work on the count.

my set analaysis :

count(distinct {<Fait_NOM={'AFFILIATION_IND_ETB'},Libelle_Produit_ORDRE={"$(=aggr(max(Libelle_Produit_ORDRE),Gamme_ID,Etablissement_ID))"}>} [_Cle_Participant])

 

the expression =aggr(max(Libelle_Produit_ORDRE),Gamme_ID,Etablissement_ID) work correctly but not in the set analysis.

 

Thanks for your help.

Sophie

0 Replies