Conditional formatting in a straight table

Wed, 28 Mar 2012 14:36:33 GMT

Hi I am new to qlikview and struggling to conditional format the dimension's background in a straight table.

Basically it is text and I want to format it so that for example the text that begins with 1 is highlighted in red, 2 is highlighed in yellow etc..

What I have done is double clicked on the background color and put in a IF statement

=IF (ward ='1*',red(),

if (ward ='2*',yellow() etc

Tried tweaking the If statement in various ways but doesn't seem to be working. Need 7 different colours. Please help if you can.

Thanks

Wed, 28 Mar 2012 14:41:16 GMT

Try this statement

= IF(ward LIKE '1*', red(),

IF(ward LIKE '2*', yellow() etc..

Wed, 28 Mar 2012 14:43:42 GMT

Thanks a lot, that worked!

topic Conditional formatting in a straight table in QlikView