Loading and Displaying Images

[#1]

Hi,

I'm a beginner with QlikView and have searched the forums for techniques to achieve what I want to do. I found a few suggestions but they all seem different or assume a level of knowledge (intelligence 😉 that I don't have at present.

I have an excel table as shown below (extract from 48 entries)

Aperture	Shutter	Picname
f2.8	1/4 sec	basicexposure_100ASA_f2_8_4.jpg
f4	1/4 sec	basicexposure_100ASA_f4_4.jpg
f5.6	1/4 sec	basicexposure_100ASA_f5_6_4.jpg
f/8	1/4 sec	basicexposure_100ASA_f8_4.jpg
f/11	1/4 sec	basicexposure_100ASA_f11_4.jpg
f/16	1/4 sec	basicexposure_100ASA_f16_4.jpg
f/22	1/4 sec	basicexposure_100ASA_f22_4.jpg
f2.8	1/8 sec	basicexposure_100ASA_f2_8_8.jpg

Picname is the actual file name of images I have stored in

C:\Media\Photos

I have created a text file in the following layout (sample extract):

Photo,I
basicexposure_100ASA_f2_8_4.jpg,C:\Media\Photos\basicexposure_100ASA_f2_8_4.jpg
basicexposure_100ASA_f4_4.jpg,C:\Media\Photos\basicexposure_100ASA_f4_4.jpg
basicexposure_100ASA_f5_6_4.jpg,C:\Media\Photos\basicexposure_100ASA_f5_6_4.jpg
basicexposure_100ASA_f8_4.jpg,C:\Media\Photos\basicexposure_100ASA_f8_4.jpg
basicexposure_100ASA_f11_4.jpg,C:\Media\Photos\basicexposure_100ASA_f11_4.jpg
basicexposure_100ASA_f16_4.jpg,C:\Media\Photos\basicexposure_100ASA_f16_4.jpg
basicexposure_100ASA_f22_4.jpg,C:\Media\Photos\basicexposure_100ASA_f22_4.jpg

I want to select a combination of aperture and shutter speed from the first table that will link to a photograph that I want to display. The 'Picname' from the first table would be used to link to the second table (first column). The second column contains the path and title of the image to be displayed.

Sounds simple but I can't get this to work.

I've had a look at Bundle and Info but I can't say I find the manuals or help facilities that clear Doooh!

Any help would be greatly appreciated.

Many thanks,

John

[#2]

I set up a quick example and with the same data setup as you have was able to get it to work. Since you want to link Picname from tabl1 and Photo from table 2, you should give them the same name. If two fields have the same name, QlikView will automatically link them.

Then for your image, use: ONLY(I). That will give you whatever image path should be shown based on your selection. It will work when there is one and only one option. You can use Max or something, but it sounds like Only is what you want. I changed the I field to FullPath in the sample.

Take a look at the sample.

[#3]

Many thanks, that does the trick and in a much simpler way than other techniques. For some reason when I tried using Bundle / Info, if I called the field names the same to forge a link, the info table didn't show when selecting Cntrl T - no worries though.

Many thanks again for your help.

Cheers,

John

[#4]

Dear Nmiller,

Hi, I am working on a Personal Edition of QV, trying to develop an app to show the pictures of a point of sale. If it works, my customer will buy the licences to install QV in his company.

Unfortunatly with the Personal Edition, I can´t see the example you sent.

It is any way I can take a look on it? Thanks a lot

[#5]

I can try to explain it, so you can recreate it for yourself. It's not too complicated.

In your load script, you need two inline loads (these are shortened, but should be sufficient)

LOAD * INLINE [
Aperture, Shutter, Picname
f2.8,1/4 sec,basicexposure_100ASA_f2_8_4.jpg
f4,1/4 sec,basicexposure_100ASA_f4_4.jpg
];
LOAD * INLINE [
Picname, FullPath
basicexposure_100ASA_f2_8_4.jpg,C:\Media\Photos\basicexposure_100ASA_f2_8_4.jpg
basicexposure_100ASA_f4_4.jpg,C:\Media\Photos\basicexposure_100ASA_f4_4.jpg
];

Then in your app, do Select Fields and show listboxes for: Aperture, Picname and Shutter.

Then create a Text Box. Set the Expression to:

=ONLY(FullPath)

and set the Presentation to Image.

If you change the FullPath values to pictures you actually have on your system, you should see that picture when the proper combination of Aperture and Shutter are selected (actually, in this simplified example, you only need to select an Aperture to show the picture).