Discussion Board for collaboration related to QlikView App Development.
I have a table. I am not sure whether i need to map but...
COUNTRY & '-' & AGENT_ID & '-' & PROD_ID as %GMS,
In my mapping excel table, i have
Client COUNTRY AGENT_ID PROD_ID
GMS DE 100 1A
GMS DE 101 2A
GMS CO 102 3A
GMS IE 103 4A
COUNTRY_CD as COUNTRY,
AGENT as AGENT_ID,
PROD as PROD_ID
The Policy Table QVD looks something like
COUNTRY AGENT_ID PROD_ID
UK 100 1A
DE 101 2A
CO 102 3A
FR 103 4A
What I want to achieve is
if any of the mappings are in the Policy table, to say that they are GMS.
If they are not in the Policy Table, they are called Non-GMS.
So I did the following in the KeyTable.
ApplyMap('GMS', %GMS, 'Non-GMS') as Result
Can anyone tell me what i am doing wrong?
ApplyMap('GMS', COUNTRY & '-' & AGENT_ID & '-' & PROD_ID, 'Non-GMS') as Result
View solution in original post