topic Re: pick latest qvd in QlikView

pick latest qvd

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

Hi All,

I want to load only the latest qvd file from the list. The qvd file has below format with timestamp.

From the above list, the latest file is 2nd one(File_01-12-2017_112912.qvd).

Please help!

Re: pick latest qvd

Chanty4u — Thu, 21 Jun 2018 07:00:49 GMT

try this

pick latest file

Re: pick latest qvd

surajdhall — Thu, 21 Jun 2018 07:23:14 GMT

Hi Chanty,

I checked this thread already, but coudn't get to the solution.

Could you please help me for my requirement.

Thanks!

Re: pick latest qvd

jyothish8807 — Thu, 21 Jun 2018 08:28:07 GMT

Hi Suraj,

Try this:

LOAD date(date#(subfield(replace(REPLACE(filename(),'.xlsx',''),'File_',''),'_',1),'DD-MM-YYYY'),'DD-MM-YYYY') as filename1,

num(subfield(replace(REPLACE(filename(),'.xlsx',''),'File_',''),'_',2)) as Filename2

FROM

(ooxml, no labels, table is Sheet1);

B1:

Load

date(max(filename1),'DD-MM-YYYY') as MaxDate

resident B;

Let vMaxDate= Peek('MaxDate',0,'B1');

Drop table B1;

Load

filename1,

max(Filename2) as MaxCount

resident B

where match(filename1,'$(vMaxDate)')

Group by filename1;

Let vMaxCount= Peek('MaxCount',0,'C');

Filnal:

Load

from

[File_$(vMaxDate)_$(vMaxCount).xlsx]

(ooxml, no labels, table is Sheet1);

drop table B;

Note: Replace .xlsx with qvd and modify the from statement. I did it using .xlsx file.

Br,

Re: pick latest qvd

jyothish8807 — Thu, 21 Jun 2018 08:29:28 GMT

Pfa sample i used

Br,

Re: pick latest qvd

qlikviewwizard — Thu, 21 Jun 2018 09:12:10 GMT

Hi,

Try this:

How to load latest month Data from Quarter QVDs SalesYYYYQ0X format – Data Analytics and BI WORLD