Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

1 Solution

Accepted Solutions
cgdonders
Partner - Creator
Partner - Creator

Hi Chris,

I Think you can use the applymap functionality to add field Excluded to table 'Data''. When field Excluded is empty (null) you can give it another value. e.g. 'Non-exluded'.

MappingTable:

mapping

LOAD

  Agency & [Bus Class] AS ID,

     Excluded

FROM

(biff, embedded labels);

Data:

LOAD Agency,

     [Bus Class],

     Premium,

     ApplyMap('MappingTable', Agency & [Bus Class], 'Non-excluded') as Excluded

FROM

(biff, embedded labels);

View solution in original post

3 Replies
cgdonders
Partner - Creator
Partner - Creator

Hi Chris,

I Think you can use the applymap functionality to add field Excluded to table 'Data''. When field Excluded is empty (null) you can give it another value. e.g. 'Non-exluded'.

MappingTable:

mapping

LOAD

  Agency & [Bus Class] AS ID,

     Excluded

FROM

(biff, embedded labels);

Data:

LOAD Agency,

     [Bus Class],

     Premium,

     ApplyMap('MappingTable', Agency & [Bus Class], 'Non-excluded') as Excluded

FROM

(biff, embedded labels);

MK_QSL
MVP
MVP

like this?

Not applicable
Author

ManyThanks Coen, spot on.