100% Stacked Bar not working Qlik Sense

[Anonymous]

Hi everybody

So I've allready read some articles for the 100% stacked bar, and none of them solved may problem.

I have a stacked chart with the following data.

note: Empresa is shown from a function, shown below.

Empresa

=If (Match(Empresa,'a','b','c'),

If ([Y/M_End]='',

If (Match([Faixa Etária],'< 25 Years','>= 25 e < 35 Years','>= 35 e < 40 Years','>= 40 Years'),Empresa)))

Faixa Etária

and for the calculation:

Count(User)/Count(Total <Empresa> User)

However it doesn's give me a total 100% by Empresa but a total on the full chart.

Additionally, is it possible to show the percentages on each part instead of the all amount?

Thank you very muche in advance.

Best Regards,

Hugo

[sunny_talwar · Accepted solution]

Can you carry out this in the script

If (Match(Empresa,'a','b','c'),

If ([Y/M_End]='',

If (Match([Faixa Etária],'< 25 Years','>= 25 e < 35 Years','>= 35 e < 40 Years','>= 40 Years'),Empresa))) as NewEmpresa

and then use NewEmpresa as your dimension and this as your expression

Count(User)/Count(Total <NewEmpresa> User)

[Anonymous]

Hi Sunny, thank you very much for the quick response

Worked like a charm

[Anonymous]

Sunny,

As a final question, is it possible to show the values in each part of the chart?

Using some formula, not using extensions.

Thank you.

[sunny_talwar]

Not sure about this as I have not worked with Qlik Sense too much to know this... sorry