Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview + Sql + image(picture)

Can somebody please tell me how can i use picture like in a sample president.qwv

i m using sql server 2005 as my database.

i will highly appreciate your help guys.....[*-)]

1 Solution

Accepted Solutions
Not applicable
Author

You have to add the bundle-load for attaching your pictures. S.th. like this:


BUNDLE INFO LOAD * INLINE [
Picture_Name, Index
Events.gif, "YOUR_PATH"\Events.gif
Income Statement.gif, "YOUR_PATH"\Income Statement.gif
Statistics.gif, "YOUR_PATH"\Statistics.gif
];



View solution in original post

7 Replies
Not applicable
Author

Hi,

i´ve attached an example which should help to understand how it works.

It doesn´t matter what kind of database you use. The trick is the bundle-load which link external media-files to your data.

Kind regards.

Not applicable
Author

Can you please try to give an example using Sql server 2005 + qlikview.

I want to see how can i get the path for the picture using sql in qlikview.... Whisper

Not applicable
Author

Ah ok, the pictures are saved in the database.

I don´t know exactly, but try something like:


BUNDLE INFO SQL SELECT
Picture, Index
FROM "YOU_DATABASE";


Not applicable
Author

Please check my attached & tell me what must i do

Not applicable
Author

You have to add the bundle-load for attaching your pictures. S.th. like this:


BUNDLE INFO LOAD * INLINE [
Picture_Name, Index
Events.gif, "YOUR_PATH"\Events.gif
Income Statement.gif, "YOUR_PATH"\Income Statement.gif
Statistics.gif, "YOUR_PATH"\Statistics.gif
];



Not applicable
Author

Thank you, this dialogue was also helped me with some doubts

Not applicable
Author

Hi,

Do you know how to remove the bundled images??

I removed the code from script editor, and reloded again. But the images still remain..