Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

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
Champion III
Champion III

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