Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

oliveihl
New 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

Re: 100% Stacked Bar not working Qlik Sense

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

Re: 100% Stacked Bar not working Qlik Sense

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)

oliveihl
New Contributor II

Re: 100% Stacked Bar not working Qlik Sense

Hi Sunny, thank you very much for the quick response

Worked like a charm


oliveihl
New Contributor II

Re: 100% Stacked Bar not working Qlik Sense

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.

Re: 100% Stacked Bar not working Qlik Sense

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

Community Browser