topic Add colored scale to a bar chart in QlikView

Add colored scale to a bar chart

alec1982 — Fri, 08 Feb 2013 21:09:54 GMT

Hi Guys,

I have a bar chart that shows horizontally scores 1 to 10 by city

I need to add colored circle or anything to reflect the value next to each dimension(bar)

Like if score = 8 and over then show green

if score between 5 and 8 show yellow and if score is less than 5 then show in red.

I have the formula for the colors but I don't know what and how to ad the colors

If((IndexTotalScore)<5, RGB(255,100,100), If((IndexTotalScore)>=5 and (IndexTotalScore)<8, RGB(255,128,0), RGB(0,128,0)))

Any suggestions?

Thxs,

Alec

Re: Add colored scale to a bar chart

Fri, 08 Feb 2013 21:31:44 GMT

Re: Add colored scale to a bar chart

alec1982 — Fri, 08 Feb 2013 21:38:08 GMT

Hey Rebecca,

I have tried to do that but the chart that I have is a stacked bar chart and it will not look nice at all in this way.

Thank you so much!

Alec

Re: Add colored scale to a bar chart

Fri, 08 Feb 2013 21:42:16 GMT

What does your data look like and what is your goal for it to look like? If you can post a sample file someone here can probably help.

Re: Add colored scale to a bar chart

alec1982 — Fri, 08 Feb 2013 22:02:56 GMT

Hi,

The first chart is how my chart looks like and the second chart is what I am trying to do(Not exactly the same but I need to distinguish the bars based on the score. so either the left side colored circles or the left scale columns would work or any idea that you have might help.

Thxs for your help!

Alec

Re: Add colored scale to a bar chart

avastani — Sat, 09 Feb 2013 05:33:52 GMT

don't know if it is doable with a stacked chart, I faced a similar problem before. you might be better off creating it as a separate chart, hide the dimension values and place it close to it.

Re: Add colored scale to a bar chart

Sun, 10 Feb 2013 19:15:15 GMT

I am not sure how you can get that effect with a stacked bar. If you could live with accumulating all the values and showing as a single bar, then you could use a mini-chart in a straight table to get a similar interface. See attached.