topic Re: Bar Chart Help in QlikView

Bar Chart Help

lockematthewp — Wed, 27 Mar 2019 20:14:30 GMT

I currently have only two fields, TotalDataPoints and BadDataPoint. I want my bar chart to have a dimension of integers from 1 to TotalDataPoints (=ValueLoop(1,TotalDataPoints,1)). My only expression is =1 so that they are all equal length bars. I have this done so far (See pic below). I would like to change the color of bars that have a dimension value equal to BadDataPoint. For example, if I have BadDataPoints of 10,25, and 40, then the corresponding bars would be colored red. I would really appreciate any help with this.

Re: Bar Chart Help

bharathadde — Wed, 27 Mar 2019 21:27:38 GMT

Use condition on background color of expression.(which is under + sign of expression)

Do you have any criteria or flag column that would determine BadDataPoints??

For suppose flag=1 is for BadDataPoints

put a condition like below in background color

= if(flag=1,red(),green())

Re: Bar Chart Help

lockematthewp — Thu, 28 Mar 2019 13:07:28 GMT

I am now getting closer to my desired result. Unfortunately, there are twice as many bars in the chart as I need. I believe this is because I am using two dimensions. The only expression is still =1. Any one know how to fix this?