Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
TKendrick20
Not applicable

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
Not applicable

Re: Using TOTAL<> With a Drill-Down Dimension

Maybe like this:

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

sunny_talwar
Not applicable

Re: Using TOTAL<> With a Drill-Down Dimension

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

swuehl
Not applicable

Re: Using TOTAL<> With a Drill-Down Dimension

Try listing all dimension fields of your drill down group:

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

TKendrick20
Not applicable

Re: Using TOTAL<> With a Drill-Down Dimension

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