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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Specialist
Specialist

Set analysis : Filter dimension

Bonjour,

Je souhaiterai avoir tous les 'Lib.Rayon(ref)' quand ma colonne 'Cd.Univers(ref)' = 83 avec un set analysis.

Je penses utiliser la fonction "IF" dans mon expression, cependant je bloque un peu

Capture.JPG

Merci d'avance

14 Replies
jmialoundama
Specialist
Specialist
Author

Yes it's work !

Thanks you

=AGGR( ONLY ( {$<[Cd. Univers (ref)]={'83'}>} [Lib. Rayon (ref)] ) , [Lib. Rayon (ref)]  )

Capture.JPG

vinieme12
Champion III
Champion III

happens with me too sometimes

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
intergnek
Partner - Contributor III
Partner - Contributor III

Ca marche très bien

jmialoundama
Specialist
Specialist
Author

Yes after i remember your answer with "onyl" function

brunobertels
Master
Master

Bonjour

Oui ne relisant les réponses des uns et des autres , je vois que j'ai mis SUM et non ONLY

Du coup çà ne peut pas marcher avec SUM

Bruno