Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

import image on the fly from web

Hi All

I have images on an oracle server I can access via a web interface by building a url.

Currently I have hyperlinks that open IE using the constructed URL, but it's a bit messy with multiple web pages opening when you view a few different images.

I can't import all the images as this would take far too long on the reload.

Is there a way I can display the image within my qlikview document? Can I screen scrape the image on the fly from the web?

Many thanks

1 Solution

Accepted Solutions
Not applicable
Author

Yes, you can.

Try the Table as below.

Pict:
LOAD * INLINE [
Nr, Picture
1, http://www.c-rural.es/moodle/file.php/1/hammer.png
2, http://trinities.org/blog/wp-content/uploads/hammer.jpg
];

Now, you have a table with two fields. Nr contains an identiefier to your picture, the field Picture the link to the picture you want to load.

Create a text object on the QV sheet.

AS Text enter "=Picture"

As Representation select "Picture" (default is Text)

Now show the Field "Nr" on the QV sheet. If you select one Number, the corresponding picture is shown.

Good luck

Michael

View solution in original post

4 Replies
Not applicable
Author

Yes, you can.

Try the Table as below.

Pict:
LOAD * INLINE [
Nr, Picture
1, http://www.c-rural.es/moodle/file.php/1/hammer.png
2, http://trinities.org/blog/wp-content/uploads/hammer.jpg
];

Now, you have a table with two fields. Nr contains an identiefier to your picture, the field Picture the link to the picture you want to load.

Create a text object on the QV sheet.

AS Text enter "=Picture"

As Representation select "Picture" (default is Text)

Now show the Field "Nr" on the QV sheet. If you select one Number, the corresponding picture is shown.

Good luck

Michael

Not applicable
Author

Hi:

Please, if I want to take a Excel file from the web, can I apply the same sentence?

Thanks [:'(]

Not applicable
Author

Hi Michael, thanks for your answer.

Can this be applied in VBScript? I can't load the pictures in the main load script as I would have to load 1000000's.

Dominic

Not applicable
Author

Hi Dominic,

i'm not aware what's the problem, sorry.

You just have to load the link of the picture into a field. The link could be read out of a database or could be calculated or whatever you want.

So, the script above is just an example to show how it works.To load all the picture physcally into memory could be a nightmare and also uses a giant amount of memory.

So, if the pciture stored on a filesystem, share or a website, just load the link and reference to the pciture.

If that answer wont help, just explain what your special situation and i would try to help.

Nice weekend & best regards

Michael