Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Visualize percent of a group who are part of another

I think my question is a variation on a theme that I'm seeing a lot, but I'm too new to be able to triangulate on the answer.

I need to see the percentage of students who are exclusively registered for online classes *within a selected other cohort*;  for instance, the age group of 25-35 year olds. 

My simple logic thought up this:  Num((Count(GCID)*100/Count(total AgeRange))/100,'##0.0%') But that's utterly incorrect.

I notice that if I click on another measure in a different chart, CAMPUS for instance, it also is filtering my Online chart that I only wanted to be affected by the AgeRange. How can I restrict the filtering?  I need each AgeRange (I have several groups) to "stand on its own".  I don't want to count total, that's merely my entire population.

Thx for any pointers.

Ceci

1 Solution

Accepted Solutions
shiveshsingh
Master
Master

You can bypass the field in your set analysis like {<CAMPUS >}

View solution in original post

4 Replies
Anonymous
Not applicable
Author

You can show data as example?

shiveshsingh
Master
Master

You can bypass the field in your set analysis like {<CAMPUS >}

Anonymous
Not applicable
Author

Thank you.  That worked. 

Num((Count ({<CAMPUS>} GCID)*100/Count(total AgeRange))/100,'##0.0%')

I've just bought a Qlik Sense book so I hope I can get up to speed with expression syntax soon. 

shiveshsingh
Master
Master

Glad to know it worked