Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stevelord
Specialist
Specialist

failover option for loading excel files?

Hi, Is there a failover script I could use for loading an alternate excel/csv file if an expected one is not present at reload time.  Say if a partner doesn't place a needed file in the ftp folder on a given night, I just have qlikview look over at some file in another folder rather than fail to load altogether?  (The qlikview still presents the file names clearly, so we'd know it was a day old file instead of a current file being referenced, but still have the rest of the dashboard data loaded up.)

Thanks!

1 Reply
maxgro
MVP
MVP

try with filesize function before loading

filesize( 'somefile.xls' )           // 0 or null = doesn't exist


here an example

How can I check if a file exists ?