topic Adjusting Captions prior to Apply Map in QlikView

Adjusting Captions prior to Apply Map

Thu, 06 Nov 2014 16:02:14 GMT

Hey Guys - I have the below, which works fine to apply most of the correct product names. I want to be able to adjust a few of the Capt_US before the map is applied.

CustomCaptions1:

Mapping LOAD

"Capt_Code" as OppoProductMap, "Capt_US" as Product

SQL SELECT...

Table:

Load

if(Oppo_Product>0,

ApplyMap('CustomCaptions1',Oppo_Product,)) as Product,

From

I tried putting: if(WildMatch(Capt_US,'*Sage 100*'),'Sage 100') as Product; in the script but that removes all other product captions.

Any thoughts?

Best,

David

Re: Adjusting Captions prior to Apply Map

rwunderlich — Thu, 06 Nov 2014 16:07:32 GMT

You are missing the "Else" in the if().

if(WildMatch(Capt_US,'*Sage 100*'),'Sage 100',ApplyMap('CustomCaptions1',Oppo_Product,)) as Product

It may be easier to adjust your mapping table to map that value directly.

-Rob

Re: Adjusting Captions prior to Apply Map

Thu, 06 Nov 2014 16:16:10 GMT

Thanks Rob! I did forget the else Capt_US at the end there.

Changing the mapping table would be much easier, but I the company won't give me access to change tables in CRM.

Re: Adjusting Captions prior to Apply Map

rwunderlich — Thu, 06 Nov 2014 17:03:05 GMT

You don't need to change the CRM source table. You can make the adjustment when you create the mapping table.

CustomCaptions1:

Mapping LOAD

"Capt_Code" as OppoProductMap,

if(WildMatch(Capt_US,'*Sage 100*'),'Sage 100', "Capt_US") as Product

SQL SELECT...

-Rob

Re: Adjusting Captions prior to Apply Map

Thu, 06 Nov 2014 17:07:33 GMT

That is what I did. Sorry, I misunderstood!!!

All the best,

David