Documents for QlikView related information.
For new comers I am Uploading example of How Apply Map works.
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/
will you please share the script because i am using personal edition
LOAD * Inline [
P9, Product1, 8, 20, 15/10/2010
P11, Product1, 7, 10, 09/10/2010
P12, Product1, 9, 20, 01/10/2010
DROP Table Purchase;
LOAD ApplyMap('Temp', Product ) as PurchasePrice,* Inline [
S1, Product1, 10, 10, 10/10/2010
Dear Sir ,
Your Post is very informative !!!
Can you Please me on following link work Bench Project White Papers with Cost I seek your valuable guidance.
Thanks for Sharing
Thank you so much for your replay,
In which scenario we are using apply map ,instead of left join
Any Specific reason please guide me i am learning Apply map function
Thanks & Regards
Consider following scenario I have zone in excel file and in my data model i have only zone code and i want to fetch zone values so I will use apply map command instead of taking hole master into Data Model.
MAPPING LOAD CODE,
ZONE as Zonee
(ooxml, embedded labels, table is Sheet1);
LocCode AS [Location Code],
Loc_name AS [Location],
ApplyMap('Map_Cfa_Zone',LocCode,0) as CFA_Zone
[Source QVDs SIM\DIM_CFAMaster.qvd]
** Please note Left join will be useful when you want to fetch all transactions code as well as desc for transactions.
Hope this will clear you .
Thank you so much for your replay,really its help full
thanks for sharing