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: 
alexis
Partner - Specialist
Partner - Specialist

Loading images from URL

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

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

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...

View solution in original post

11 Replies
petter
Partner - Champion III
Partner - Champion III

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

2015-05-10 #1.PNG

petter
Partner - Champion III
Partner - Champion III

The load script looks like this:

2015-05-10 #2.PNG

alexis
Partner - Specialist
Partner - Specialist
Author

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

alexis
Partner - Specialist
Partner - Specialist
Author

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_...

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:

URLIMage.jpg

Thanks Petter

Alexis

petter
Partner - Champion III
Partner - Champion III

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...

alexis
Partner - Specialist
Partner - Specialist
Author

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

petter
Partner - Champion III
Partner - Champion III

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...

arieidel
Partner - Creator II
Partner - Creator II

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

petter
Partner - Champion III
Partner - Champion III

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.