Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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.

qlik chart.PNG

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

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)

View solution in original post

4 Replies
Highlighted

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)

View solution in original post

Highlighted
Contributor II
Contributor II

Hi Sunny, thank you very much for the quick response

Worked like a charm


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

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