Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
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)
I use your expression , but i get the chart not like your. where i go wrong ?
I found the answer , i should not click on relative . now working fine.
You need to untick relative under Expressions.
that will allow you to have same chart.
FYI just realised that set MAX Static scale as 1 make it easier to read.
Yep that is it.
It is simpler than you thought.