Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

import image on the fly from web

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

4 Replies
Not applicable

import image on the fly from web

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

import image on the fly from web

Hi:

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

Thanks [:'(]

Not applicable

import image on the fly from web

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

import image on the fly from web

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

Community Browser