topic Re: Cyclic group with multiple colors in QlikView

Cyclic group with multiple colors

vinod2086 — Fri, 22 Aug 2014 07:53:48 GMT

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.

Re: Cyclic group with multiple colors

MK_QSL — Fri, 22 Aug 2014 07:57:57 GMT

Provide sample data please

Re: Cyclic group with multiple colors

veidlburkhard — Fri, 22 Aug 2014 08:18:08 GMT

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

Re: Cyclic group with multiple colors

Anonymous — Fri, 22 Aug 2014 09:57:00 GMT

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