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: 
Not applicable

How can I show percentages in a bar chart? Every column sum 100%

I need to show the percentages in every column of a bar chart.

This is my expression:

COUNT({<SampleType={'Tender'}>}DISTINCT [Sampling Order Header ID])

Please help.

13 Replies
Not applicable
Author

Hello Sunny

This is my chart.

I used your expression: 

Count({<SampleType={'Tender'}>}DISTINCT [Sampling Order Header ID])

/Count(TOTAL <Origin> {<SampleType={'Tender'}>}DISTINCT [Sampling Order Header ID])

and did not work.

For Vietnam, I need 50% and 50%.

Please, help.

2016-06-14_11-27-43.jpg

sunny_talwar

Are you using 2 expression and 1 dimension or 1 dimension or 2 expressions?

Can you share the how do you define your dimension and expressions?

Not applicable
Author

2 dimensions: 1. Origin:  IF(MATCH(SampleType,'Tender') AND LEN(Origin)>1, Origin)

                     2.  Cupping Results : IF(MATCH(SampleType,'Tender ') AND LEN(Origin)>1,[Cupping Results])

1 expression: 

Count({<SampleType={'Tender'}>}DISTINCT [Sampling Order Header ID])

/Count(TOTAL<Origin> {<SampleType={'Tender'}>}DISTINCT [Sampling Order Header ID])

amonjaras
Partner - Creator II
Partner - Creator II

Ouch! TOTAL does not work with calculated dimensions

If you can pre-calculate your dimensions in the script then you can use it.

Hope this helps!