Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dselgo_eidex
Partner - Creator III
Partner - Creator III

TOTAL Qualifier with Alternative Dimensions

Hello, I am having a problem with using the TOTAL qualifier on a chart that makes use of different alternative dimensions.

Basically, I have a stacked bar chart that is showing demographic information for a population. I want to show the percentage breakdown of the population by different dimensions (e.g. Ethnicity, Gender, etc.).

scrshot1_07172018.PNG

My expressions for this chart is:

count([Person]) / count(TOTAL<[Ethnicity]> [Person])


This gives me the ideal behavior for the chart. The issue is when I introduce alternative dimensions. For example, the following chart where the dimensions are switched:

scrshot2_07172018.PNG

Because the TOTAL qualifier is still excluding <Ethnicity>, my chart is not behaving how I want it to. Basically, I want to be able to set the expression to something like the following:

count([Person]) / count(TOTAL<["X-axis Dimension"]> [Person])


Does anybody know how I could accomplish this?

1 Solution

Accepted Solutions
dselgo_eidex
Partner - Creator III
Partner - Creator III
Author

Figured it out. Have to use GetObjectField(0)

count([Person]) / count(TOTAL<$(=GetObjectField(0))> [Person])

View solution in original post

2 Replies
dselgo_eidex
Partner - Creator III
Partner - Creator III
Author

Figured it out. Have to use GetObjectField(0)

count([Person]) / count(TOTAL<$(=GetObjectField(0))> [Person])

Tyler_Waterfall
Employee
Employee

Thanks for posting. Helped me today.