8 Replies Latest reply: Nov 24, 2017 5:08 AM by Antonio Mancini RSS

    if on same column - qlik sense

    Joanna Seldon

      hi

       

      I have this in a filter pane

       

      trying to do an if on same column, with no joy

       

      if(match([Department],'Catering','Homeware'),'x',if([Department]=Catering','y','OTHER'))

       

      I cant seem to get y to appear

       

      any help team please