topic Re: Colors in linear gauge in QlikView

Colors in linear gauge

Anonymous — Thu, 26 Dec 2013 13:26:24 GMT

Hello,

I'm trying to represent some values in a pivot table as linear gauges. I did that, but now I need to color each "Categoria / Marca" with an custom RGB that I have in an inline.

This is how the table actually looks:

The expression that I'm using in the "Segment" color is:

If($(vRegDemCat) = 2, Only({<Categoria_Marca>} RGB(R, G, B)))

I don't know what is wrong and why the dimensions aren't getting their colors.

Thanks a lot.

Kindest regards!

Re: Colors in linear gauge

Gysbert_Wassenaar — Thu, 26 Dec 2013 13:55:53 GMT

A set analysis expression creates one set per chart, not a set per dimension value. That's why your expression doesn't work. Perhaps this will do the job: If($(vRegDemCat) = 2, RGB(R, G, B)).

If not take a look at this blog post: Colors in charts

Re: Colors in linear gauge

Anonymous — Thu, 26 Dec 2013 16:07:15 GMT

Hi, I have tried that and I didn't get any result, all I got is the same green for all dimensions.