topic Re: How to load Last 9 days data in QlikView

How to load Last 9 days data

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

Hi Experts,

Can any one please help me on this.

In a folder daily with corresponding date one excel file will be updated.

From those excel file names I have extracted the date like below.

When I have run the script on tomorrow then one more date will be added. But here I have to restrict only Last 9 days data.

Thanks in advance.

shiveshsingh — Sun, 18 Feb 2018 02:11:41 GMT

Try this

LOAD Date

FROM test_data.xlsx

(ooxml, embedded labels, table is Sheet1);

NoConcatenate

load *

Resident T;

drop table T;

max:

load max(Date) as max_date

Resident W;

let vMAX = peek('max_date',0,'max');

NoConcatenate

Final:

load *

Resident W

where Date> Date('$(vMAX)'-9,'DD-MM-YYYY');

DROP TABLE W;