Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
qlikuser222
Contributor

Dynamically loading Excel sheets?

Hi Everyone,

I have a requirement where we need to load sheet n excel files dynamically.

For 2016 file we have sheet names like Jan, feb ..... dec

For 2017 file we have sheet names like Jan, feb ..... dec

but in 2018 sheets names are only from Jan to Aug and next month we will receive Sep.

Qlik is loading fine till 2018 Aug, but it gives error since Sept file is not available.

Can anyone please help me to load files incrementally with all sheets.

Thanks