topic Re: How do I show images on selection by the user? in QlikView

How do I show images on selection by the user?

alisonpwallis — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to load student images into a dashboard so when the user selects the ID for that student, the image appears. I have bundle loaded a table in script with two fields - first the ID which then joins to other data within the dashboard and secondly a field containing the filepath to the image. The load appears to work but I cannot get the text object to show the photos:

I create a text object, put in the code

=info([Student ID])

and change the Representation to Image. I also set it to be conditional so it only shows when just one Student ID is selected. This just shows '-' rather than the image. However, if I go into the expression and select images from the tabs at the bottom, I can select 'Student ID/' from the Image Folder drop down list but then it just lists all the images for me (and I can see them) but they don't appear in the text box. I want to just see the image depending on the selected Student ID.

The thing that seems to be missing is something like 'qmem' - this appears in all the other examples I've found when you look a the text object properties BUT I can't get this to change anywhere.

Can anyone help?

Thanks

Alison

Re: How do I show images on selection by the user?

awhitfield — Wed, 24 Aug 2016 10:14:51 GMT

Hi Alison,

have you checked out this posting?

https://community.qlik.com/blogs/qlikviewdesignblog/2013/05/31/loading-images-into-qlikview

HTH

Andy

Re: How do I show images on selection by the user?

alisonpwallis — Wed, 24 Aug 2016 10:16:50 GMT

Hi Andy

Thanks - I've had a look through that one and I've done everything it says but I still can't seem to get it to work.

Thanks

Alison

Re: How do I show images on selection by the user?

Anonymous — Wed, 24 Aug 2016 10:18:34 GMT

Have a look:

Bundle Info Load

Hope it helps!!

Re: How do I show images on selection by the user?

alisonpwallis — Wed, 24 Aug 2016 10:42:47 GMT

Hi Anil

Thanks for this link - it has helped me a bit! Now I have a chart (straight table) that shows the photos BUT it won't show a photo when just one ID is selected (which is what I need to show!).

Any ideas why this might be the case?

Thanks

Alison

Re: How do I show images on selection by the user?

Anonymous — Wed, 24 Aug 2016 10:45:24 GMT

Post Sample Screen shot what you are getting

Re: How do I show images on selection by the user?

awhitfield — Wed, 24 Aug 2016 10:47:29 GMT

Hi Alison,

could you upload a sample app?

Andy

Re: How do I show images on selection by the user?

alisonpwallis — Wed, 24 Aug 2016 10:48:56 GMT

Hi Anil,

Here's two screenshots. The first when I don't select a particular person and the second when I have selected one by their ID.

Thanks

Alison

Re: How do I show images on selection by the user?

Anonymous — Wed, 24 Aug 2016 11:00:23 GMT

Try keep " No Totals " in Expression tab

Re: How do I show images on selection by the user?

alisonpwallis — Wed, 24 Aug 2016 11:07:47 GMT

Hi Andy

I can't upload the actual sample file as it contains personal photos of students. I have tried to create another file with some sample files and this time it worked! This makes me think it is either to do with the file format (I am uploading bmp files) or the upload process (I am loading from an Oracle server). But I don't understand why I can see the photos when I have all of them there but not one on its own.

Thanks for your help

Alison

Re: How do I show images on selection by the user?

Anonymous — Wed, 24 Aug 2016 11:17:02 GMT

Hi,

Check this sample attached file

hope it helps!! !

Re: How do I show images on selection by the user?

awhitfield — Wed, 24 Aug 2016 11:21:27 GMT

No Problem,

can you post the section of the screen that you run for the bundle load, and the expressions page from the chart properties?

Andy

Re: How do I show images on selection by the user?

alisonpwallis — Wed, 24 Aug 2016 11:55:31 GMT

Hi Andy

Sorry for the delay. I was trying out something.

I've attached the screenshot of the load - the commented out section is how i was originally loading the files in using SQL. I tried creating an excel file with the images in and that didn't work. The next thing I tried was renaming the field in the bundle load so it wasn't a key with an existing field (seems like it needs to be an orphan?) And this worked! But without joining it to the other data it is not so useful - it means users will probably have to select the ID twice - once for most data and once for the photo.

Any ideas?

Thanks

Alison

Re: How do I show images on selection by the user?

santiago_respane — Wed, 24 Aug 2016 12:07:26 GMT

Hi,

try bundle load as follows.

In script:

bundle load * inline [

imgName,img

img1,C:\Temp\srespane\Education\QV Samples\Infographics\img1.png

img2,C:\Temp\srespane\Education\QV Samples\Infographics\img2.png

];

Then in your text object you will need to add the desired image as follows (don't forget to set Image as value forRepresentation in text object properties General tab):

='qmem://imgName/img1' //For image 1

='qmem://imgName/img2' //For image 2

Please let me know if this helps.

kind regards,

Re: How do I show images on selection by the user?

alisonpwallis — Wed, 24 Aug 2016 12:27:30 GMT

I saved the file and closed it and opened it again and it appears to now be working. Not sure at all why this is the case but lets hope it stays that way.

Thanks for your help

Alison

Re: How do I show images on selection by the user?

awhitfield — Wed, 24 Aug 2016 13:12:16 GMT

Nice one!

Re: How do I show images on selection by the user?

santiago_respane — Wed, 24 Aug 2016 13:14:36 GMT

Hi, if your issue was solved please remember to mark the answers that helped you as Helpfull or correct in order to close the issue.

Kind regards,