Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

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
Contributor

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

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)

5 Replies
john9inno
Contributor

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

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
Valued Contributor II

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

Hi Sir

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

Paul

paulyeo11
Valued Contributor II

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

Hi Sir

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

Thank you

Paul

john9inno
Contributor

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

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
Contributor

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


Yep that is it.

It is simpler than you thought.

Community Browser