topic Re: How to load latest QVD in application in QlikView

How to load latest QVD in application

pra_kale — Tue, 21 Mar 2017 15:55:39 GMT

Hi,

In a one folder i have a premium Qvd's Year wise like Premium_2000, Premium_2001, Premium_2013, Premium_2017...

Year starts from April To March. So current year is 2017.

In a application i want to load latest QVD on the basis of Year automatically..i.e. without mentioning year at the end. Application will load QVD on the basis of current year...

Please help to resolve the issue.

Thanks in Advance.

Re: How to load latest QVD in application

swuehl — Tue, 21 Mar 2017 15:57:33 GMT

You should be able to follow the same like shown in

Load latest Excel file to Qlikview

Re: How to load latest QVD in application

pra_kale — Tue, 21 Mar 2017 16:37:24 GMT

Thanks Stefan for your help..

I have made below given changes but it is giving error...I think i am missing something. Can you please help.

LET vFilePath = 'E:\Qlikview\A';

FOR EACH file in FileList('$(vFilePath)\*.qvd');

LET vFileYear = Left(Right(file,8),4);

LET vMaxYear = Rangemax(vFileYear,vMaxYear);

Data:

LOAD *

FROM

[$(vFilePath )\Premium_$(vMaxYear).qvd](qvd);

Re: How to load latest QVD in application

swuehl — Tue, 21 Mar 2017 16:42:05 GMT

You are missing a NEXT statement, right?

If that's not the solution, what does the error message say?

Re: How to load latest QVD in application

pra_kale — Tue, 21 Mar 2017 17:18:55 GMT

You are right...i have missed Next statement..It is working now..

Great Thanks..