# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
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