topic Re: Bar Graph Colors Specific to Value? in QlikView

Bar Graph Colors Specific to Value?

Fri, 10 Aug 2012 15:50:45 GMT

This may be impossible, but I have a graph that shows 2 dimensions (stacked): Total Tickets Submitted and Urgency. I have set the colors to show as follows:

However, when you select a single user that does not have all the Urgency fields present, the colors default to the beginning. If I select the User on the far left of the image above:

Is there a way to specify in the bar graph colors that 'Urgent' always equals Red, 'Very High' always equals Orange, etc.?

Re: Bar Graph Colors Specific to Value?

Nicole-Smith — Fri, 10 Aug 2012 15:57:22 GMT

Instead of setting the colors on the Colors tab, you need to write a Background Color Expression for it for each of your expression(s):

Re: Bar Graph Colors Specific to Value?

Fri, 10 Aug 2012 16:18:27 GMT

Would you be able to provide a test file by chance? I don't think I understand how the expression can change the color.

Re: Bar Graph Colors Specific to Value?

Nicole-Smith — Fri, 10 Aug 2012 16:31:15 GMT

Here you go.

You can use rgb values for the colors, i.e. red would be rgb(255, 0, 0).

Re: Bar Graph Colors Specific to Value?

Fri, 10 Aug 2012 16:48:12 GMT

That is exactly what I was looking for. Thank you!!!