Skip to main content

Francophones

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead 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)

Thanks in advance,

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

View solution in original post

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

er_mohit
Master II
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.

Example.bmp

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 🙂