20 Replies Latest reply: Apr 28, 2016 3:02 AM by Laura Castagna RSS

    not equal to statement, qlikview

    Laura Castagna

      Hi,

       

      where am I going wrong here please?

       

       

      I want to say if field State is not ‘NSW','VIC','QLD','WA','AC','NT','TAS' or 'SA' then make it ‘Other’

       

       

       

      =if(State-={‘NSW','VIC','QLD','WA','AC','NT','TAS','SA'},'Other',State)

       

      Any help appreciated.

      LC