topic Re: How to Get Values in One Table in QlikView

How to Get Values in One Table

alvinford — Wed, 12 Dec 2012 17:34:26 GMT

Hi ,

I have 2 QVDs Temp and Temp2. Monthly Amount is in my Temp2 Table. My requirement is, For the Key values found in the Temp table the MonthlyAmount has to be calculated from Termstart to TermEnd Date (i.e to overwrite the Startdate and EndDate values in the Temp2 with TermstartDate and TermEndDate for the key Values from Temp) The MonthlyAmount for Key Value in the Temp2 remains same..

Please find the attached QVDs.

Please guide me to achieve this ..

Temp:

LOAD Key,

     TermEndDate,

     TermStartDate

FROM

Temp.Qvd

(qvd);

Temp2:

LOAD Key,

     BuildingID,

     UnitID,

     ChargeTypeID,

     StartDate,

     EndDate,

     MonthlyAmount

FROM

Temp2.Qvd

(qvd);

Re: How to Get Values in One Table

CELAMBARASAN — Wed, 12 Dec 2012 17:52:12 GMT

Try with this

Temp2:

LOAD Key,

     BuildingID,

     UnitID,

     ChargeTypeID,

     //StartDate, //Remove this field

     //EndDate, //Remove this field

     MonthlyAmount

FROM

Temp2.Qvd

(qvd);

left join

LOAD Key,

TermEndDate AS EndDate,

TermStartDate AS StartDate

FROM

Temp.Qvd

(qvd);

Re: How to Get Values in One Table

alvinford — Wed, 12 Dec 2012 23:00:07 GMT

Hi Adimulam,

If I remove the Startdate and enddate I cant get the startdate and End Date for the values in Table Temp2.

Regards,

Alvin.