Showing photos in the Straight Table object

[#1]

Hello, hello,

I'm familiar with the presidents.qvw and I used it to get this as a prototype. But, I can't use a plain sequence but dynamic code files with various coding conventions in various locations (numbers and letters). Is there a way to get something like this in the Straight Table object if I name photos as codes?

Thank you,

Nenad

[#2]

Please do the below:

Make and expresssion like ='qmem://Photo/'&Only(ID)&'.bmp'.

Idea is to convert your ID to the ImageDirectory/ImageName with extension.

Hope this helps,

Kiran.

[#3]

Thank you Kiran. I've tried but got only the expression in the cell: 'qmem:\\Photos\Clipboard01.jpg' and not the acutal photo.

[#4]

You should have the representation of the expression as image.

Kiran.

[#5]

I know and I did. What is exactly the structure I need to use? for axample if I have something like this:

'\\servername\sharefolder\subfolder\'&Only(ID)&'.jpg' BTW: What does the Only function do?

[#6]

Hi!
Another posibility is to load all the files from a xls file, or using an Inline load, like:

PHOTOS:

LOAD * INLINE [

ID,PHOTO_NAME,Filename

1001, DESCRIPTION1.JPG, "\\servername\sharefolder\DESCRIPTION1.JPG"

1002, ....]

Then, the dimensions should be: ID, Description (whatever name they have), and the expression should be "=Filename"

Hope it helps....

Regards!

[#7]

Its seems you didnt do a bundle load as the folder isnt qmem. I recommemed bundle load for quick response and network share path may not work on access point.

Only function will the only possible value or null.

Regards,

Kiran.

[#8]

Thanks Kiran, I got it work on my computer for very simple case.

From where does QV reads photos and bundles them into qvw as I didn't place a folder and they are not present in the qvw folder?

I understand you but there is a possible problem if you have like 4000 entities with photos like 100KB each which will be 360MB large qvw. In addition, I need to use link type of expression to show specs or similar so I need access to shared folders anyway.

Thanks a lot. This can be used in some limited situations.

Best regards,

Nenad

[#9]

Thanks Pato, this is more open solution. I only have problem when I run the qvw from the Access Point. I have all permissions to the shared folder but no photo shown.

Any idea?

Best regards,

Nenad

[#10]

Nenad,

The possible alternatives are:

1) In the dashboard you need low resolution image like 50x50. Images in your server are higher resolution and more size. If you can size the 400 images to 50x50, the size will cut down drastically and bundle load them into your dashboard. Qlikview will further compress them and the size will be resonably low.

Advantange is that all your images will be similar in dimensions in your dashboard. Besides we cannot accuratly judge the image size unless you try it out. I recomment you try this with 100 scaled images.

2) If your users are in the same network, you can host the images thru webservice and call the image in the dashboard. Instead of .j.j\\se.. you will have http://image1.jpg. The only drawback is maintainance of additional service.

Qlikview can bundle roll images from any windows directory or webservice. Check out presidents.qvw in the examples provided.

PS: You can do bulk scaling of images using Microsoft Office Picture Manager.

Regards,

Kiran.