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:

       

      data.jpg

      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?

       

      Regards,

      Daniel M