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: 
Not applicable

Syntax with function Count

Hello everyone.

I would like percentages rather than values. So I tried to use the TOTAL with function Count but it does not work.

Does anyone have an idea?
 

count (DISTINCT{$<date_entree={"<>0"}>} Matricule)

/

count (DISTINCT TOTAL {$<date_entree={"<>0"}>} Matricule)

Thanks in advance,

Emmanuelle

--------------------------------------------------------------------------------------------------------------------------------------

Bonjour tout le monde,

J'aimerais avoir des pourcentages plutôt que des valeurs. Donc j'ai essayé d'utiliser le TOTAL mais cela ne marche pas.

count (DISTINCT{$<date_entree={"<>0"}>} Matricule)

/

count (DISTINCT TOTAL {$<date_entree={"<>0"}>} Matricule)

Quelqu'un aurait-il une idée ?

Emmanuelle

10 Replies
maxgro
MVP
MVP

please post your qvw as it seems to me that some of the answers should work