Discussion Board for collaboration related to Creating Analytics for QlikView.
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
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.
Go to Solution.
Consider that your have below script..
Load * Inline
This will give you list box where customer having sales <> 0.
Type this in Listbox Expression.
This will give you list box where customer having no sales
Thanks, this really helped