Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Pericator
Contributor III
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
Contributor III
Contributor III
Author

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

View solution in original post

4 Replies
Pericator
Contributor III
Contributor III
Author

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

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

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

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