Stacked Bar Chart

[DrDanSzuhay]

Hello Qlik Community,

I am fairly new to utilizing Qlik and this is my second posting. I will do my best to ask my question. 

We have developed a stacked bar chart:

The Stack Dimension = "Admission Program"

The Bars Dimension = "Progress Note (New).Language in which service was provided Value"

The Alternative Dimension = "Progress Note (New).If patients preferred language is NOT English, we Value"

And the Length of Bars Measure = "Count([Progress Note (New).ID])"

The percentage that the stacked bar is showing is the percentage of a particular language chosen in a progress note for an Admission Program against the total number of progress notes for all Admission Programs. (e.g. 3 progress notes had Chinese chosen as the language for Recovery Inc and the total progress notes for ALL providers is 100 the percentage shown for Recovery Inc is 3/100)

However, we want the denominator NOT to be the total number of progress notes, but rather the total # of progress notes only for that particular Admission Program (e.g. 3 progress notes had Chinese chosen as the language for Recovery Inc and the total progress notes for Recovery Inc is 25 then we want the percentage shown to be 3/25)

I have found a way to do this by choosing Modifier, Selection Scope, Current Selection

Is there any way to do this by hard coding it (e.g. putting something into the Length of Bars Measure expression "Count([Progress Note (New).ID])") so the user doesn't have to choose an Admission program to make the stacked bar chart show the percentages we want?

In other words, is there way to have the stacked bar chart show percentages of progress notes with a particular chosen language hard coded by Admission Program not by the total of all Admission Programs?

Thank you.

[MatheusC]

Enter the dimension you want to total within the total qualifier <>

Count([Progress Note (New).ID] )
/
Count (total < Dimension > [Progress Note (New).ID])


- Regards

[DrDanSzuhay]

Unfortunately MatheusC your suggestion did not work......

GOOD NEWS! We were able to figure it out! 

Here is the solution:

For a stacked bar chart, to make a measure show precents choose the Modifier "Relative Numbers" and to then to have the denominator be by Admission Program, choose Dimensional Scope "Respect One Dimension" and then Dimension (to be respected) "Admission Program" That solved the problem!