topic Re: Adding while Loading in QlikView

Adding while Loading

praveenkumar_s — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How can i acheive this ,during loading

Load EmployeeID, sum(Actualhrs)+sum(Billedhrs)as Totalhrs resident PPMS_PROJECTRESOURCES;

sunny_talwar — Fri, 06 Jan 2017 13:22:55 GMT

Do you want this?

Load EmployeeID,

RangeSum(Actualhrs, Billedhrs) as Totalhrs

Resident PPMS_PROJECTRESOURCES;

Or this:

Load EmployeeID,

Sum(Actualhrs) + Sum(Billedhrs) as Totalhrs

Resident PPMS_PROJECTRESOURCES

Group By EmployeeID;

surendraj — Fri, 06 Jan 2017 13:31:17 GMT

Hi,

you can try it with preceeding load,

load EmployeeID,sum(Actualhrs)+sum(Billedhrs) as Totalhrs Group By EmployeeID;

LOAD * INLINE [

EmployeeID, Actualhrs, Billedhrs

1, 5, 6

2, 7, 9

];

--surendra

praveenkumar_s — Mon, 09 Jan 2017 06:06:49 GMT

Exactly....what i want ... thank u very much..

surendraj — Mon, 09 Jan 2017 06:13:28 GMT

Hi Praveen Kumar,

please close the thread if you got the relevant one.

--surendra