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: 
paulyeo11
Master
Master

How to make my stack bar chart for reject and production same length ?

Hi All

I have a chart which display reject qty and product Qty by product line. which showing 2 Bar , one is very long another one is very short. So it is hard to know which product line have more reject.

So i convert the chart to stack chart , again i can know which product line have more reject compare to total production qty.

So i convert the both expression to display relative value , this time some bar become long and some become short.

my question is how to make all bar same length ?

Enclosed my QVW file.

Paul

1 Solution

Accepted Solutions
john9inno
Creator
Creator

Is this what you aim to acheive?

Bar chart.gif

below is expressions that i used.

reject = count(Aggr(NODISTINCT kode_reject,date_time))/sum(product_total)

Production = 1 - count(Aggr(NODISTINCT kode_reject,date_time))/sum(product_total)

View solution in original post

5 Replies
john9inno
Creator
Creator

Is this what you aim to acheive?

Bar chart.gif

below is expressions that i used.

reject = count(Aggr(NODISTINCT kode_reject,date_time))/sum(product_total)

Production = 1 - count(Aggr(NODISTINCT kode_reject,date_time))/sum(product_total)

paulyeo11
Master
Master
Author

Hi Sir

I use your expression , but i get the chart not like your. where i go wrong ?

Paul

paulyeo11
Master
Master
Author

Hi Sir

I found the answer , i should not click on relative . now working fine.

Thank you

Paul

john9inno
Creator
Creator

You need to untick relative under Expressions.

that will allow you to have same chart.

thanks.

FYI just realised that set MAX  Static scale as 1 make it easier to read.

john9inno
Creator
Creator


Yep that is it.

It is simpler than you thought.