Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);
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);
like this?
ManyThanks Coen, spot on.