topic Automatic Update in QlikView

Automatic Update

andrea90casa — Tue, 16 Jan 2018 15:57:53 GMT

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 — Tue, 16 Jan 2018 16:02:07 GMT

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 — Tue, 16 Jan 2018 16:03:31 GMT

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 — Tue, 16 Jan 2018 16:07:04 GMT

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 — Tue, 16 Jan 2018 16:10:04 GMT

You can do it like this