topic Re: Loading images from URL in QlikView

Loading images from URL

alexis — Sun, 10 May 2015 05:39:31 GMT

I have an application that shows a list of products in a list box - the requirement is to display the image of the product when a user selects a single entry from the list box. The client has the images on their website and can only provide me URLs for them. Does anyone know how I can achieve this?

Thanks in advance

Alexis

Re: Loading images from URL

petter — Sun, 10 May 2015 06:23:59 GMT

There are several ways of doing it:

1) You can do an INFO LOAD in your load script where you provide two columns - the first for the description and the second for the URL. When you make a list box you will only see the first column available as a field. When you select a particular item in the list box you will see an icon in the top right of the title bar of the list box. Then you can click that to open a separate window with an image.

2) You can also display images directly as entries in a list box then you don't need an INFO LOAD but rather a regular LOAD with a list of URL's. In the list box on the presentation tab you can select under Image Options / Representation Image in the dropdown.

I have attached the simple demo with list box. Of course you can do this in Charts too. There you will can also specify Link as a Presentation option. And use an expression like this ='Dolly Duck<URL>link adress'.

Re: Loading images from URL

petter — Sun, 10 May 2015 06:27:40 GMT

The load script looks like this:

Re: Loading images from URL

alexis — Sun, 10 May 2015 20:06:00 GMT

Hi Petter

THANK YOU so much for your reply and apologies for not responding earlier but I was out of town and just returned.

Your example was very helpful indeed especially the INFO LOAD part.
Is there a way that I can have a list box(say) of the text (as you have it in the list box (Txt)) and the image of the item clicked to be shown in a separate text box without having to click on the "i" in the list box?

Thanks again

Alexis

Re: Loading images from URL

alexis — Sun, 10 May 2015 20:22:08 GMT

Actually I think you have helped me find the solution:

a) In my script I dropped the "INFO"part:

Image3:

LOAD * INLINE [

Item, URLLink

QlikView (the unbeatable all-rounder), http://upload.wikimedia.org/wikipedia/commons/thumb/0/09/QlikTech_20xx_logo.svg/320px-QlikTech_20xx_logo.svg.png

Tableau (super-Excel), http://upload.wikimedia.org/wikipedia/commons/0/01/Tableau_Software_Logo_Small.png

];

b) I created a text box and set it up as follows:

Thanks Petter

Alexis

Re: Loading images from URL

petter — Sun, 10 May 2015 21:47:53 GMT

Yes that is quite easy:

1) Make a regular List Box with the field Desc.

2) Make a Text Box and put in the expression: MinString(URL)

Under Representation on the General Tab select Image in the drop-down menu

Then the associative logic of QlikView will select the corresponding URL which will be used in the

text box to show the image of the URL.

I specify MinString() so there will be always one image shown ... even if none or multiple images are selected.

I attached an updated QVW that shows how it is done...

Re: Loading images from URL

alexis — Sun, 10 May 2015 21:57:36 GMT

Thanks again - this is almost identical to my solution which I posted earlier (after my reply to you) which is shown as "Being moderated" for some reason - never had that before.

One exception with your solution is the use of MinString(URL) I just use "=URL" - I was not aware of this command - very helpful indeed.

Thanks again
Alexis

Re: Loading images from URL

petter — Sun, 10 May 2015 22:07:14 GMT

You're welcome

The reason it is showing as being moderated is that you have included some URL of some sort and to avoid spam there is manual intervention to approve the posts...

Re: Loading images from URL

arieidel — Fri, 06 Nov 2015 18:24:30 GMT

Hello Petter,

I'm just needing a solution like this one. And despite that this works in my QlikView Desktop, I can't make it work when I publish it on the web server. Images just don't show up.

Do you know why is that and how can I solve it?

Thanks!

Ariel

Re: Loading images from URL

petter — Sat, 07 Nov 2015 05:06:59 GMT

If your URL's are http URL's then the only thing that I know of that could prevent it is either that the WebServer has no access to the internet or the specific sites are blocked from that server.

Re: Loading images from URL

arieidel — Mon, 09 Nov 2015 18:53:02 GMT

Hello Petter,

We've verified that the web server has access to that site with its service account.

In fact, now I know what the problem is. QlikView doesn't allow or accept image URLs which includes %20 (space char encoded).

For example:

http://www.mysite.com/my%20images/my%20image.jpg --> This won't work in QV

http://www.mysite.com/my_images/my_image.jpg --> This would work in QV

Do you know how to encode/decode URL?

I've also tried using just the space (not '%20') but it doesn't work neither.

Thanks,

Ariel

Re: Loading images from URL

arieidel — Thu, 12 Nov 2015 16:02:38 GMT

Any help on this situation?

Thanks!