2 Replies Latest reply: Feb 13, 2014 2:50 AM by cocoy jurado RSS

    Listbox showing items not belonging to the criteria

      New to qlikview, I would like to ask for help with regards to selection of exclusions.  What kind of expression would satisy this criteria?

       

      1. I have a List of Customers which is linked to a sales transaction table

      2.  I filter and select certain criteria on the transaction table and naturally it shows the customers with those transactions

       

      Question:

       

      How can I create a listbox which shows all customers which do not have transactions or exclusion to the selected criteria?

      What expression do I use?  Help would be very much appreciated.