Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Pericator
New Contributor III

Stacked Bar chart with 100%

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

 

1 Solution

Accepted Solutions
Pericator
New Contributor III

Re: Stacked Bar chart with 100%

I fixed it, I had to use count(PAYMENT_TYPE) / count(total <Country>PAYMENT_TYPE) as Measure.
4 Replies
Pericator
New Contributor III

Re: Stacked Bar chart with 100%

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
Contributor III

Re: Stacked Bar chart with 100%

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
New Contributor III

Re: Stacked Bar chart with 100%

But it seems there are plenty out there already?
Pericator
New Contributor III

Re: Stacked Bar chart with 100%

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