Stacked Bar chart with 100%

[Pericator]

Hi Community,

I got a problem with creating a stacked bar chart which shows 100% of each Country. So I got 4 different payment types per Country, and of course they are used in different percentages. I want a stacked bar chart, showing Country and Payment Type as Dimension plus the Percentages of the different payment types in Stacks.

Dimension1: CountryName

Dimension2: PAYMENT_TYPE

Measure: count(PAYMENT_TYPE) / count(total PAYMENT_TYPE)

Sadly it doesnt work for me, see attached image pls.

Thanks in Advance

Pericator

[Pericator]

It seems to work fine, if I just filter one Country, then it goes up to 100%. I think it divides the Percentage of every single Country by the total of all Countries instead of just the one.

[igdrazil]

Hi Pericator!

There'll be a new option with the next version for Qlik (April 2019), which let's you choose to show data as a 100% chart. The new version will release somewhen this month.

Regards
Chris

[Pericator]

But it seems there are plenty out there already?

[Pericator · Accepted solution]

I fixed it, I had to use count(PAYMENT_TYPE) / count(total <Country>PAYMENT_TYPE) as Measure.