# Francophones

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
Not applicable

## Set analysis problem ?

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)

Emmanuelle

P.S. : My expression is found in the graph at the top right in the INPUT tab-output

1 Solution

Accepted Solutions
Not applicable
Author

Bonjour Emanuelle,

try this expression, the total is bounded to "ANNEE_DATE_ENTREE". Should work as expected.

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

/

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

RR

7 Replies
Not applicable
Author

Emmanuelle

don't understand very well

check if it is what you want

christian

Not applicable
Author

If you want percentages rather than values, just write a normal simple expression and then check the "Relative" option. If that gives you weird numbers, instead add " & '%' " to the end of your expression.

Cheers,

Lucas

Master II

See the attached file

try this

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

/

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

Not applicable
Author

I tried this too, but this is not quite right. I would like my total percentage for 2013 is equal to 100%, the same for 2014.

Is that possible to do that ?

Emmanuelle

Not applicable
Author

Emmanuelle

here it is

christian

Not applicable
Author

Bonjour Emanuelle,

try this expression, the total is bounded to "ANNEE_DATE_ENTREE". Should work as expected.

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

/

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

RR

Not applicable
Author

I have a small gap in 2013 but I know how to explain. That's perfect.

Thank you Roland and everybody for your help 🙂

Tags