Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You should be able to follow the same like shown in
You should be able to follow the same like shown in
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);
You are missing a NEXT statement, right?
If that's not the solution, what does the error message say?
You are right...i have missed Next statement..It is working now..
Great Thanks..