topic Re: Help on Applymap Statement in QlikView

Help on Applymap Statement

Fri, 17 May 2013 20:24:56 GMT

Hi Community

I have a problem with an applymap statement as it's not applying the map for some reason and i am lost why it's not working hopefully you can help me

the code is as below:

//******************************************************************************** LOAD MAPPING TABLES ***********************************************************************************//

KACParentAccountDetails:

Mapping

LOAD CompanyDetails.CompanyCode,

CompanyDetails.AccountContractManagerName

FROM

C:\Users\Manager\Dropbox\Qlikview\KA\KACParentAccountDetails.qvd

(qvd);

//******************************************************************************** LOAD MAIN DATA TABLES ***********************************************************************************//

KAmaster:

LOAD CompanyDetails.CompanyID,

CompanyDetails.CompanyCode,

CompanyDetails.ParentAccountID,

Applymap('KACParentAccountDetails',CompanyDetails.ParentAccountID,'') as ContractManagerName,

CompanyDetails.AccountContractManagerName

FROM

C:\Users\Manager\Dropbox\Qlikview\KA\CompanyDetails.qvd

(qvd)

Re: Help on Applymap Statement

Anonymous — Fri, 17 May 2013 20:41:52 GMT

James,

I don't see anyhting wrong with the script. Except, I recommend to use always mapping load distinct, except for inline load. If anything is wrong, it is likely with the data.

Regards,

Michael

Re: Help on Applymap Statement

Fri, 17 May 2013 20:46:42 GMT

Hi Michael

both CompanyDetails.ParentAccountID and CompanyDetails.CompanyCode are numerical fields, i have added a test app to this post if you need to see the data behind the code!

Regards

James

Re: Help on Applymap Statement

vidyut — Fri, 17 May 2013 20:54:46 GMT

Hi James,

I don't see anything wrong with your script. Will you be able to provide the Mapping Load QVD File?

Regards,

Vidyut

Re: Help on Applymap Statement

Fri, 17 May 2013 21:07:15 GMT

Hi Vidyut

Mapping File is attached now. thanks

Re: Help on Applymap Statement

vidyut — Fri, 17 May 2013 21:15:49 GMT

Now, Could you please find a Company in KAMaster with a Parent Company ID that is present in this Mapping QVD? That would help in resolving your issue.

Thanks,

Vidyut

Re: Help on Applymap Statement

Fri, 17 May 2013 21:24:41 GMT

the parent 547348 should linked to 32 child account vidyut

Re: Help on Applymap Statement

vidyut — Sat, 18 May 2013 08:11:20 GMT

Hi James,

Problem is with the ParentCompanyID, which is in Text Format instead of Number due to training spaces etc. So it you use

Applymap('KACParentAccountDetails',Num(Trim(CompanyDetails.ParentAccountID)), '') as ContractManagerName,

This should resolve your issue.

Hint: When you put a listbox for a field, the text is left aligned, and the numbers are right aligned.

Re: Help on Applymap Statement

Sat, 18 May 2013 10:45:53 GMT

Thanks Vidyut

so your converting the field to a number then using trim to remove all training spaces etc, you have been a great help