topic Re: Mixmatch maybe? in QlikView

Mixmatch maybe?

bobbydave — Wed, 25 Nov 2020 16:16:04 GMT

I have a Mapping table:

MapGMSScheme:
Mapping LOAD
COUNTRY_CD & '-' & AGENT & '-' & Scheme_SDB as %GMS,
PROD_NAME
FROM
[$(vMapping)\GMS_Scheme.xlsx]
(ooxml, embedded labels, table is GMS_Schemes);

I then have a Policy table

PolicySummary:
Load COUNTRY_CODE & '-' & ACC_PERIOD & '-' & SCHEME&MEASURE_TYPE as %Product_detail,
COUNTRY_CODE,
AGENT_NAME,
PRODUCT_TYPE as PRODUCT_TYPE_SUM,
PRODUCT as PRODUCT_SUM,
PRODUCT_NAME as PRODUCT_NAME_SUM,
SCHEME as SCHEME_SUM,

MixMatch(ApplyMap('MapGMSScheme', COUNTRY_CODE & '-' & AGENT_NAME & '-' & SCHEME, 'NONE'), 'GMS',
if(COUNTRY_CODE & '-' & AGENT_NAME & '-' &
'Non-GMS') as %GMS

FROM
[$(vQVDPath)\POL_DASH_DTLS.qvd]
(qvd);

and then a KeyTable

What I am trying to achieve is to compare the COUNTRY_CD & '-' & AGENT & '-' & Scheme_SDB as %GMS, from the mapping table with the

COUNTRY_CD & '-' & AGENT_NAME & '-' & SCHEME from the Policy Table.

If matching, it says 'GMS', if not, to say 'Non-GMS'

Help appreciated

Re: Mixmatch maybe?

Anonymous — Fri, 31 Mar 2017 09:24:20 GMT

Hi,

I'm not sure if this is what you want,

IF(ApplyMap('MapGMSScheme', COUNTRY_CODE & '-' & AGENT_NAME & '-' & SCHEME, 'NONE') = 'NONE', 'Non-GMS', 'GMS')

this condition will get the value from the mapping table, if it's none as you have set above, it will output Non-GMS else GMS

Re: Mixmatch maybe?

hemanthaanichet — Fri, 31 Mar 2017 09:28:27 GMT

Can you have any sample data so that i can work on it.....

Re: Mixmatch maybe?

stabben23 — Fri, 31 Mar 2017 09:53:06 GMT

Hi David,

try With this:

IF(ApplyMap('MapGMSScheme', COUNTRY_CODE & '-' & AGENT_NAME & '-' & SCHEME, 'NONE') =COUNTRY_CD & '-' & AGENT_NAME & '-' & SCHEME ,'GMS','Non-GMS') as %GMS

Use above solution from Yddonna, this is not working.

Re: Mixmatch maybe?

bobbydave — Tue, 18 Apr 2017 13:40:41 GMT

i see what you are doing but from

PolicySummary:

Load COUNTRY_CODE & '-' & ACC_PERIOD & '-' & SCHEME&MEASURE_TYPE as %Product_detail,
COUNTRY_CODE,
AGENT_NAME,
PRODUCT_TYPE as PRODUCT_TYPE_SUM,
PRODUCT as PRODUCT_SUM,
PRODUCT_NAME as PRODUCT_NAME_SUM,
SCHEME as SCHEME_SUM,

I want to look in the above table and then see if COUNTRY_CD & '-' & AGENT & '-' & Scheme_SDB are the same as what is in my mapping table, to categorise the matching ones as GMS, else Non-GMS.

Would your expression not just return Non-GMS?

Re: Mixmatch maybe?

bobbydave — Tue, 18 Apr 2017 13:40:47 GMT

i see what you are doing but from

PolicySummary:

I want to look in the above table and then see if COUNTRY_CD & '-' & AGENT & '-' & Scheme_SDB are the same as what is in my mapping table, to categorise the matching ones as GMS, else Non-GMS.

Would your expression not just return Non-GMS?