Discussion board where members can get started with Qlik Sense.
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.
If (Match([Faixa Etária],'< 25 Years','>= 25 e < 35 Years','>= 35 e < 40 Years','>= 40 Years'),Empresa)))
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.
Can you carry out this in the script
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
Hi Sunny, thank you very much for the quick response
Worked like a charm
As a final question, is it possible to show the values in each part of the chart?
Using some formula, not using extensions.
Not sure about this as I have not worked with Qlik Sense too much to know this... sorry