3 Replies Latest reply: Mar 14, 2014 7:32 AM by Chris McGrath RSS

    Query with regard to filtering data - Please Help!!


      Hi, I have 2 lists of information. The first list contains information regarding over 100 agencies across 15 lines of business.

       

      The second list is a list of agencies and their excluded business lines.

       

      I have combined the 2 list and am able to view the total data, and can filter to the data on the excluded lines, but what I can't do is filter out the excluded business to just leave the non-excluded business.

       

      Any thoughts?

       

      I have recreated the issue in a very simplified version in the attached files. If you have a solution please could you let me have this in narrative rather than update my file, as I am still using my Personal version of Qlikview while I try and build a Business Case to purchase licences.

       

      All help would be most welcome.