Visualize percent of a group who are part of another

[Anonymous]

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

[Anonymous]

You can show data as example?

[shiveshsingh · Accepted solution]

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

[Anonymous]

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]

Glad to know it worked