4 Replies Latest reply: Dec 10, 2016 3:46 AM by Massimo Grossi

# Logic

Dear Team,

I stuck a requirement.

Supoose we have a sale data Only 3 dec 2016

ID       Date              Site     Sale

101      3-dec-2016          A       100

102      3-dec-2016          A       200

103      3-dec-2016          A       300

104      3-dec-2016          A       400

I loaded in qlikview And Store 3 dec data in qvd.... And delete excel file from source where sale data is kept.

Then next day 4 dec 2016 new excel file is updated in data sorce.

When i load in qlikview and save the data in qvd....and delete the execl from source.....

But when i reach 5 dec 2016 then i updated the data of 3 dec 2016....above id 101 regading sale is coming 100..But it should be 1000...

When i new excel file 3 dec 2016 is loaded again..then it show sum of sale regarding 101 means 1100..But it should be Only 1000.

How is possible in qlikview..

Kindly help me..

• ###### Re: Logic

Hi,

You need to use Incremental load logic to achieve this.

But I doubt for the ID 101 on 3Dec, the sales is 100 only. if you sum up based on date it will 1000.

• ###### Re: Logic

Could you post some more data from the excel source, 4 and 5 december

and the expected result?

• ###### Re: Logic

Dear Sir,

Pfa the Data

• ###### Re: Logic

Hope to understand, PFA

//

// make qvd for test

//

for sheet=3 to 6

LET file='201612' & num(\$(sheet), '00') & '.qvd';

Data:

LOAD Site, ID, Date(Date) as Date, Sale

FROM   [Data For Testing.xlsx] (ooxml, embedded labels, table is [\$(sheet) Dec]);

STORE Data into [\$(file)] (qvd);

DROP Table Data;

next;

//

// read qvd in descending order

//

for day=6 to 3 step -1

LET file='201612' & num(\$(day), '00') & '.qvd';

TRACE \$(file);

Data: