Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
frank_bossuyt
Partner - Contributor
Partner - Contributor

test if image is exists after bundle load

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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')

View solution in original post

1 Reply
swuehl
MVP
MVP

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')