topic Re: Cyclic Group - colors in QlikView

Cyclic Group - colors

Mon, 10 Oct 2011 10:17:08 GMT

I have a cyclic group as a dimension.

This cyclic group is made up of 3 dummy variables (yes/no)

I have a bar chart using this cyclic group.

yes should be displayed as a green bar, no as a red bar.

However, for one of the 3 fields in the cyclic group, this is vice versa (no is green, yes is red).

I can't seem to change this...

any ideas?

its_anandrjs — Mon, 10 Oct 2011 10:17:39 GMT

Hi,

Write a code some thing like in the background properties of the chart by click on + sigh and add this code there

If( YourField = Yes,Green( ), if( Yourfield = No, Red( ), Black( ) )

If you have any sample file so share it.

Rgds

Anand

SunilChauhan — Mon, 10 Oct 2011 10:26:40 GMT

in express -> click on + sign -> background color->use the formula

if(col1='Yes' or col2='Yes' or Col3='No',Green(),Red())

you can set this formula for yes and no as you required i.e which one you want green and what you want red

Mon, 10 Oct 2011 12:45:14 GMT

Thanks for the help.

However, this still didn't work out for me.

I've found a solution though...

Apperently the difference in color was caused by a different sort order... so make sure all fields in your cyclic group are sorted the same way...

Furthermore, on the "sort" tab of your chart, make sure "override group sort order" is not selected.