5 Replies Latest reply: Dec 5, 2017 10:19 AM by daniel melo RSS

    Help on set analysis Qlik Sense

    daniel melo

      Hi experts,


      Giving this table:



      I need to show only person id, who have a action different of  U5 with the folowing list of Action Reason reason: U2, Z1.

      So in this case, it should exclude Person ID: 3048, 6037, 8311, 11530.

      I'm trying this but it doesn`t work:

      =if([Action]='U5'] and [Action Reason]<>'U2' or [Action Reason]<>'Z1',[Person ID])


      What am I missing?



      Daniel M