8 Replies Latest reply: Nov 9, 2015 7:31 AM by Joanna Seldon RSS

    if statement for colour expression

    Joanna Seldon


      Hiya

       

      in qlik sense, I am using a Pivot table.

       

      I am trying to write a if statement for different conditions to, change either the background colour or

       

      I need to able able to define two conditions or 3 conditions are matched

       

      e.g

       

       

      IF(Library =  '1' and  Cafe = '0',  rgb(153,102,0),

       

      issue I have is using the same line but in different context

       

      IF(Library =  '1' and  QSRoom = '0',  rgb(153,102,0),.... I want this to go the same colour but it does not change

       

       

      also having issues when defining 3 conditions

       

      IF(Library =  '1' and  Cafe = '0' and QSRoom = '0',  rgb(153,102,0),

       

      please help