topic Re: Dimension Colours in QlikView

Dimension Colours

Thu, 11 Jun 2015 08:01:25 GMT

How do I define a colour for a specific dimension in a bar chart ?

eg In the pic below.... I want to define a colour for 'SLA Breached' and for 'Unknown', etc.....

The reason being, sometime 'Unknown' end up as being first in the list, then it takes up the first colour and so on. Now I want it to keep it's colour no matter where in the list it falls.

Re: Dimension Colours

sushil353 — Thu, 11 Jun 2015 08:05:15 GMT

in expression click on + sign and then write condition like

pick(Match(Dimension,'SLA Breached','Unknown','Awaiting information','Danger'),color(1),color(2),color(3),Color(4))

you can define these color in color tab.

HTH

Sushil

Re: Dimension Colours

vishsaggi — Thu, 11 Jun 2015 08:07:06 GMT

Hi Bradley,

Can you upload you sample app we can work on.

Thanks,
V.

Re: Dimension Colours

Thu, 11 Jun 2015 08:40:19 GMT

Hi Bradley,

I just tried Sushil Kumar's suggestion

Have a look at attached qvw.

Re: Dimension Colours

Thu, 11 Jun 2015 08:56:16 GMT

This is so COOL Sushil.

Thanks man !!! It works. Well done !!!!

Appreciate your help !!!!

Re: Dimension Colours

sushil353 — Thu, 11 Jun 2015 10:38:15 GMT

Cheers !!!

there is one shortcut for this:

color(Match(Dimension,'SLA Breached','Unknown','Awaiting information','Danger'))

Re: Dimension Colours

Thu, 11 Jun 2015 10:50:19 GMT

Great ! I'll give that a try as well !!