6 Replies Latest reply: Sep 25, 2017 11:40 PM by eduard Hörhager RSS

    Which person has red and blue und NOT yellow or NOT black?

    eduard Hörhager

      Hi all,


      Tab1(color):

      red

      green

      yellow

      blue

      black

       

      Tab2(person):

      Hans

      Martin

      Mark

       

      Tab3(person,color):

      Hans, red

      Hans, blue

      Martin, red

      Martin, blue

      Martin, yellow

      Martin, blue

      Mark, black

       

      Now I need an answer for this Question:

      which person has red and blue und NOT yellow or NOT black?

      in the example form above the answer is: Hans, Mark

       

      How can I solve this in Qlikview?
      the user must be able to change the negative and positive values at any time.

       

      THANK YOU FOR ANY HELP?