Automatic Update

[andrea90casa]

Hi Community,

I have a question:

Is it possible to update the file of dataset in automatically?

For example every weekend a specific software produce a sales report and it called single report in this way:

Sales_Week_1

Sales_Week_2

Sales_Week_3

....

And go on

Is it possibile, every week, to connect automatically a Qlik view application with the latest Sales_Week file?

Thanks in advance

[YoussefBelloum]

Hi,

I think it can be done.. you want reload all the files including the latest one ? or just reload only the lastest one from the list ?

[swuehl]

You are talking about a scheduled reload of your QV document?

And to load data from a file with the pattern Sales_Week_X where X is an incremental number?

Yes, both is possible.

[andrea90casa]

Hi Youssef

Files are in .xlsx format.

And I need reload only the latest one.

For example when the system upload sales data from Sales_Week_1.xlsx to Sales_Week_2.xlsx I need only data in the Sales_Week_2 file.

Andrea

[swuehl · Accepted solution]

You can do it like this

Load latest Excel file to Qlikview