Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')