topic Re: Apply Map issue in QlikView

Apply Map issue

Anonymous — Tue, 23 Sep 2014 10:58:08 GMT

Hi folks,

I am not getting the apply map field in my app... Below is my code... thanks in advance...

StandardCost_Map:

MAPPING LOAD

ProductID,

StandardCost;

SQL SELECT * FROM Product;

SalesOrderDetail:

LOAD

CarrierTrackingNumber,

DueDate,

OrderQty,

ProductID,

SalesOrderDetailID,

OrderQty*UnitPrice - UnitPriceDiscount AS Sales,

ApplyMap('StandardCost_Map','ProductID','0') AS ProductStandardCost;

Re: Apply Map issue

senpradip007 — Tue, 23 Sep 2014 10:59:49 GMT

venkat vemula wrote:

Hi folks,

I am not getting the apply map field in my app... Below is my code... thanks in advance...

StandardCost_Map:

MAPPING LOAD

    ProductID,

    StandardCost;

SQL SELECT * FROM Product;

SalesOrderDetail:

LOAD

    CarrierTrackingNumber,

    DueDate,

    OrderQty,

    ProductID,

    SalesOrderDetailID,

    OrderQty*UnitPrice - UnitPriceDiscount AS Sales,

    ApplyMap('StandardCost_Map','ProductID','0') AS ProductStandardCost;

Try like:

Load

.....

ApplyMap('StandardCost_Map',ProductID,'0') AS ProductStandardCost

From <>;

Re: Apply Map issue

ashfaq_haseeb — Tue, 23 Sep 2014 11:02:07 GMT

Like this

ApplyMap('StandardCost_Map',ProductID,'0') AS ProductStandardCost;

Regards

ASHFAQ

Re: Apply Map issue

avinashelite — Tue, 23 Sep 2014 11:02:18 GMT

Hi,

Remove the Single cotes for ProductID

ApplyMap('StandardCost_Map',ProductID,'0') AS ProductStandardCost;

Re: Apply Map issue

Anonymous — Tue, 23 Sep 2014 11:04:13 GMT

Thanks Pradeep.....