Documents for QlikView related information.
Hope all are doing good. The attached QVW refers Applymap breifly. It explain the functionalities about Apply map function. Hope this will helps you guys
Thanks & Regards
Helpful.... If you want to know better use of applymap... Read below...
Thanks for sharing this. ApplyMap is perhaps my favourite of all QlikView functions, I have blogged on its use here: http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/
Simple to understand nice one.
will you please share the script because i am using personal edition
Load * Inline [
LOAD * Inline [
ApplyMap('A',ID,'NOT MAPPED') as Applymapfield
DROP Table B;
In which scenario we are using applymap ,instead of left join
Any Specific reason please guide me i am learning Apply map function
The ApplyMap function is used for mapping any expression to a previously loaded mapping table
Assume that you have one master table and one temp table
in master table you have Branch Code and Branch name is available....... and in Temp table Branchcode and Merged Branch code is available. With the help of that branch code you want to map and get the branch name. find the below example script you will get an idea.
Mapping LOAD * Inline [
left(BranchCode,3) as code,
if(left(BranchCode,3)<>MergeCode,MergeCode,left(BranchCode,3)) as NewBranch
DROP Table A;
ApplyMap('Master',NewBranch,'Not Mapped') as BranchCodeNew
Load the above script in your application and reload..Then in front end take the table box and add the all fields. Finally you will get some Idea. Hope this will clear you
Thank you so much for your replay,really its help full