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?
Maybe like this:
Count([Respondent ID]) / Count(TOTAL <$(='[' & GetCurrentField([Group Name]) & ']')> [Respondent ID])
My bad, this is Qlik Sense. This might not work for Qlik Sense
Try listing all dimension fields of your drill down group:
COUNT([Respondent ID]) / COUNT(TOTAL <[Question], Group, Answer, AnotherField> [Respondent ID])
Yeah, that doesn't work. I can't figure out how to reference the value of the drill-down dimension.