Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
TKendrick20
Partner - Specialist
Partner - Specialist

Using TOTAL<> With a Drill-Down Dimension

I have a drill down dimension that allows me to drill down into a stacked bar chart three levels. However, I want this bar chart to be a 100% bar chart where all the bars take up 100% of the x-axis, and I understand I need to use the TOTAL<> function. Something like this:

COUNT([Respondent ID]) / COUNT(TOTAL <[Question]> [Respondent ID])


I need to reference the drill-down dimension instead of a static [Question] field. Is this possible so I can turn this chart into a 100% chart?

Bar Chart Snip.PNG

4 Replies
sunny_talwar

Maybe like this:

Count([Respondent ID]) / Count(TOTAL <$(='[' & GetCurrentField([Group Name]) & ']')> [Respondent ID])

sunny_talwar

My bad, this is Qlik Sense. This might not work for Qlik Sense

swuehl
MVP
MVP

Try listing all dimension fields of your drill down group:

COUNT([Respondent ID]) / COUNT(TOTAL <[Question], Group, Answer, AnotherField> [Respondent ID])

TKendrick20
Partner - Specialist
Partner - Specialist
Author

Yeah, that doesn't work. I can't figure out how to reference the value of the drill-down dimension.