Qlikview Pivot table , liner gauge chart segment color by dimension

[davidgabisonia]

Hello ,

I'm working on qlikview document,  we have a pivot table and one expression is as liner gauge chart, the thing is that  the liner gauge chart segment color should be calculated by dimension value, If dimension field "dim" contains the values A, B, C the liner gauge chart segment color should be: for value A-red, B-green, C-blue.

in the segment color expression i wrote the code

if(dim='A',red(), black()) but for all dimension the color is black

Please need kind help

[farru_scorpio]

Hi David,

Please use below condition in Dimension Color Properties by clicking on "+" icon to expand.

=IF( DIM = 'A',red(),if(DIM = 'B',Green(),if(DIM = 'C',Blue(),'')))

Cheers

[rohitraut]

Try this,

Pick(wildmatch(Dim,'A','B','C'),RGB(255,0,0),RGB(0,0,255),RGB(0,128,0))

OR

Pick(wildmatch(Dim,'A','B','C'),Red(),Green(),Blue())

[davidgabisonia]

Hi ,

Thanks for your suggestions.

It does not take any effect, it's seem that the liner gauge segment color expression does not reacts on dimension value in the pivot table.

it's the link of sample qlikview document

sample.qvw - Google Drive

in the pivot table, I want to change the liner gauge segment color depending on the dimension value, for example for DIM Camel it must be red !