Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Apply Map Concept

vikasmahajan
Not applicable

Apply Map Concept

For new comers I am Uploading example of How Apply Map works.

Thanks

Vikas

Tags (1)
Attachments
Comments
stevedark
Not applicable

Hi Vikas,

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/

- Steve

NavinReddy
Not applicable

Hi

will you please share the script because i am using personal edition

Regards,

Niranjan

vikasmahajan
Not applicable

Purchase:

LOAD * Inline [

PurchaseID,Product,PurchasePrice,Quantity,PurchaseDate

P9, Product1, 8,  20, 15/10/2010

P11, Product1, 7,  10, 09/10/2010

P12, Product1, 9,  20, 01/10/2010

];

Temp:

Mapping LOAD

Product,PurchasePrice

Resident Purchase;

DROP Table Purchase;

Sales:

LOAD ApplyMap('Temp', Product ) as PurchasePrice,* Inline [

SalesID,Product,SalesPrice,Quantity,SalesDate

S1, Product1, 10,  10, 10/10/2010

];

output :

ProductPurchasePriceQuantitySalesDateSalesIDSalesPrice
Product181010/10/2010S110

Thanks

Vikas

vikasmahajan
Not applicable

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

Vikas

NavinReddy
Not applicable

Hi Vikas

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

Niranjan

vikasmahajan
Not applicable

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.

Map_Cfa_Zone:

MAPPING LOAD CODE,

  ZONE as Zonee

FROM

(ooxml, embedded labels, table is Sheet1);

DIM_CFAMaster:

LOAD

  //LocId,

     LocCode AS [Location Code],

     Loc_name AS [Location],

    ApplyMap('Map_Cfa_Zone',LocCode,0) as CFA_Zone

  from

[Source QVDs SIM\DIM_CFAMaster.qvd]

(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 .

Vikas

NavinReddy
Not applicable

Hi Vikas

Thank you so much for your replay,really its help full

Thanks & Regards

Niranjan

ysj
Not applicable

thanks for sharing

Version history
Revision #:
1 of 1
Last update:
‎01-30-2014 06:06 AM
Updated by: