topic Qlikview Pivot table , liner gauge chart segment color by dimension in QlikView

Qlikview Pivot table , liner gauge chart segment color by dimension

davidgabisonia — Fri, 01 Sep 2017 10:17:06 GMT

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

Re: Qlikview Pivot table , liner gauge chart segment color by dimension

farru_scorpio — Sun, 03 Sep 2017 11:59:29 GMT

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

Re: Qlikview Pivot table , liner gauge chart segment color by dimension

rohitraut — Sun, 03 Sep 2017 13:03:00 GMT

Try this,

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

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

Re: Qlikview Pivot table , liner gauge chart segment color by dimension

davidgabisonia — Tue, 05 Sep 2017 08:51:40 GMT

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 !