How to Calculate the Values...

alvinford — Wed, 12 Dec 2012 23:06:12 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 ) 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);

Regards,

Alvin.

Re: How to Calculate the Values...

sivarajs — Thu, 13 Dec 2012 05:13:37 GMT

Rename StartDate asTermStartDate and EndDate as TermEndDate

Now both the table is connected . You can use the expression to calculate monthly amount

topic How to Calculate the Values... in QlikView

How to Calculate the Values...

Re: How to Calculate the Values...