topic Re: How to make my stack bar chart for reject and production same length ? in QlikView

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

paulyeo11 — Wed, 29 Jul 2015 23:52:15 GMT

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

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

john9inno — Thu, 30 Jul 2015 01:22:18 GMT

Is this what you aim to acheive?

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)

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

paulyeo11 — Thu, 30 Jul 2015 03:00:52 GMT

Hi Sir

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

Paul

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

paulyeo11 — Thu, 30 Jul 2015 03:14:14 GMT

Hi Sir

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

Thank you

Paul

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

john9inno — Thu, 30 Jul 2015 03:15:31 GMT

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.

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

john9inno — Thu, 30 Jul 2015 03:17:27 GMT

Yep that is it.

It is simpler than you thought.