Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dselgo_eidex
Contributor II

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
Contributor II

Re: TOTAL Qualifier with Alternative Dimensions

Figured it out. Have to use GetObjectField(0)

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

1 Reply
dselgo_eidex
Contributor II

Re: TOTAL Qualifier with Alternative Dimensions

Figured it out. Have to use GetObjectField(0)

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

Community Browser