Load Latest Excel file from folder

[qlikview979]

Hi Experts,

I have one folder like "Data" in this folder i am adding every day one Excel file  .

20160101

20160102

20160103

20160104

20160105

i loaded the all files and i done the designing  in  front end .

Dimension :- NAME

Expression:SUM(SALES)

if  i add one file tomorrow when i go for reload all files are loading and it was taken more time.

Here  i want one reload the new file and  i need to show all excel file data in front end?

How can i do this can any one file Example

[qlikview979]

Hi Varsha,

Please Check my Second attached file. how data is file

Regards,

Mahesh

[varshavig12]

Yes, it will load all the data.

But this time, it will load the data directly from the data source only for the new file i.e. 20160105 

and the previous data from qvds.

[jonathandienst]

Are you saying it did not work, or you don't know how it works?

If it not working, you did include the first block of code -- thats where the variable is defined?