Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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())
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
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 !