Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can bypass the field in your set analysis like {<CAMPUS >}
You can show data as example?
You can bypass the field in your set analysis like {<CAMPUS >}
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.
Glad to know it worked