topic Conditional format in QlikView

Conditional format

Wed, 04 Apr 2012 08:09:26 GMT

Hello

I have created a pivot table with two dimensions e.g department, pay level and some expressions e.g current permanant workforce, Temp, etc. Now I have dragged pay-level under the expression. What I am trying to do is formulate an IF statement so that each pay-level (the whole column say under Permanent staff) will be different colours. The following doesn't seem to work.

if(perm_staff = 'Pay a', 'blue()', if(perm_staff = 'Pay b', 'Yellow ()'.....

I have written this statement under background colour of Perm_staff.

Please help

Thanks

Conditional format

CELAMBARASAN — Wed, 04 Apr 2012 08:15:29 GMT

Hi,

Change it to like this

if(perm_staff = 'Pay a', blue(), if(perm_staff = 'Pay b', Yellow().....

Celambarasan

Re: Conditional format

Wed, 04 Apr 2012 08:26:26 GMT

Hi Celambarasan, I have already tried that and it does not work.

Re: Conditional format

Wed, 04 Apr 2012 08:33:13 GMT

Hi I think I've sorted it by changing perm_staff to 'Pay level'

Thanks all that had a look.