test if image is exists after bundle load

frank_bossuyt — Wed, 10 Jul 2013 09:01:02 GMT

Is there an function that can tell you if an image exist or nog in QlikView after the images are load using the bundle statement?

The reason is that I want to have a default image when there is no image found.

Thnx

Frank

Re: test if image is exists after bundle load

swuehl — Wed, 10 Jul 2013 10:50:18 GMT

Frank,

you can set your image ID only when the file exists, like

Images:

Bundle LOAD if(FileSize(Path),ID ) as ID, Path INLINE [

ID,Path

1,'Image1.jpg'

2,'ImageNotExists.jpg'

];

Then check on existence of your ID in your expression:

=if(only({<ID = {2}>} ID), 'qmem://ID/2','qmem://ID/1')