2 Replies Latest reply: Mar 28, 2012 10:43 AM by shah0786 RSS

    Conditional formatting in a straight table


      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.