# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for
Did you mean:
Highlighted
Contributor II

## 100% Stacked Bar not working Qlik Sense

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

1 Solution

Accepted Solutions
Highlighted
MVP

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)

4 Replies
Highlighted
MVP

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)

Highlighted
Contributor II

Hi Sunny, thank you very much for the quick response

Worked like a charm

Highlighted
Contributor II

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.

Highlighted
MVP

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