Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.


Colors in linear gauge


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:

pintar imagen.jpg

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!

2 Replies

Re: Colors in linear gauge

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

talk is cheap, supply exceeds demand

Re: Colors in linear gauge

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

Community Browser