Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dasaradh
Contributor III
Contributor III

how can we Automate script to pull the next data from xls?

Hi,

i have dash board which is build on march month data from excel.

i would like to do automate to pull the data  from excel of April. how can we do that.

is there any automated script for this, if yes how can we achieve it?

thanks,

Dasaradh

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Reload the document if the data for april is added to the same excel file as the data from march.

Change the script to load all the excel files if the data for each month is stored in separate excel files.

See for example this discussion: loop through to load all files from a folder and its subfolders?


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Reload the document if the data for april is added to the same excel file as the data from march.

Change the script to load all the excel files if the data for each month is stored in separate excel files.

See for example this discussion: loop through to load all files from a folder and its subfolders?


talk is cheap, supply exceeds demand

View solution in original post