Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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