Map Load/Join Issue

Anonymous — Sun, 17 Mar 2013 22:17:20 GMT

Hi,

I am trying to map the aggregated value to the actual result set for the month end value. We are trying to popualted agregated sum for month end date remainging days we want to populated with Unknown or 0 value.

Here is the code:

map:

MAPPING LOAD calendar_date,

month_end_vehicle_tna as month_end_sales

FROM

J:\tmp\Sapient\DataViz\EARPhase\3_QVD\Layer_2\AUM_Transformed_View_Agr.qvd

(qvd);

LOAD

calendar_date,

month_end_date,

Vehicle_TNA as sales,

APPLYMAP('map', calendar_date,0) AS month_end_sales_final

FROM

J:\tmp\Sapient\DataViz\EARPhase\3_QVD\Layer_2\Master_Calendar_Trn.qvd

(qvd) ;

The issues is evethough we had calendar date (03/31/2011) present in both the record sets also it is showing uknown assets instead of showing the actual value .Attached the qvw file.

Thanks

Dasu.G

Re: Map Load/Join Issue

Mon, 18 Mar 2013 09:24:12 GMT

Give different alias name for calendar_date and convert it from string to date in each record set and try again.

Re: Map Load/Join Issue

er_mohit — Mon, 18 Mar 2013 09:29:41 GMT

write in both table Date(calendar_date,'MM/DD/YYYY')AS calendar_date

instead of simply write calendar_date

topic Map Load/Join Issue in QlikView

Map Load/Join Issue

Re: Map Load/Join Issue

Re: Map Load/Join Issue