Cyclic group with multiple colors

[vinod2086]

Hi friends,

i'm working on bar chart in that chart we are using one cyclic group contains 3 dimensions( Region, Severity, incident type)

but the problem is when i select severity (major,minor,negligible) it should be displayed in different colors but remaining region and incident type should be in single color, is it possible in Qlikview Pls help me.

Thanks in advance.

[MK_QSL]

Provide sample data please

[veidlburkhard]

Hi Vinod,

you can use 'GetCurrentField' to identify the dimension which is currently used in your group. With this you can define the colors of your chart conditionally.

Hope this helps

Burkhard

[Anonymous · Accepted solution]

Hi vinod,

In Background colour of the severity dimension please give below syntax:

=

If(Severity= 'Minor', RGB(168, 189, 11),
If(Severity= 'Major', RGB(255, 214, 0),
If(Severity= 'Negligeble', RGB(228, 31, 31))))

Do the same for remaining.

Hope it helps

Cheers

Nitha