8 Replies Latest reply: Apr 18, 2013 8:51 AM by Kaushik Solanki RSS

    a AND b NOT c

      Hi,

       

      Let say that I have a Transaction table that contains customer name, product name, and price.

       

       

      NameProductPrice

      Andy

      Shoes100
      BrettShirts200
      RobertShoes300
      RobertShirts350
      RobertLaptop1000
      Andy Shirt200
      BrettShoes200

       

      I want to be able to display this data in QlikView Dashboard and I want the user to make a selection visually for a person that buy shoes AND shirts but NOT laptop

      which if done correctly will result in Andy and Brett.

       

      Any guidance how to do this? Do I need to apply macro?

       

      Thanks!