How to show several images?

[#1]

Having application there one invoice can have from zero to say max 10

attached files. Mainly images (tif, jpg, ...) but also pdf:s and web pages.

Have not found out how to provide user access to attached files.

One possible solution I'm trying is to provide 10 small push buttons having

as action "Open URL". Labels for buttons may be simply numbers from 1 to 10.

But I do not know how to connect attachment 1 to push button 1, att 2 to pb 2,

and so on and how to disable rest of buttons having no attached image/file.

Doc_id is the primary key in the load script

Invoices:

LOAD doc_id,

     ...

     other fields

Attachments:

LOAD doc_id,

     doc_page, // 1, 2, ...

     doc_id & '-' & doc_page as pictureID

     file_name

     ...

For one attachment per invoice all is fine and Push button's Open URL works

for different file types But for more ...?

Instead of ten buttons there could be Next and Previous buttons but again

I do not know how to connect images to the them and manage disablings and

enablings.

Suggestions?

TT

[#2 · Accepted solution]

In order to understand your request better:

Do you want a link for each attachment or do you want to show the images in the application where they exist, and links where pdf and webpages are?

One solution if all attachments should be through links could be (assuming each attachment is connected to one doc_page):

Invoices:

LOAD doc_id,

     ...

     other fields

Attachments:

LOAD doc_id,

     doc_page, // 1, 2, ...

     doc_id & '-' & doc_page as pictureID

     file_name

     file_path //complete path i.e. C:\users\johnsmith\documents\invoice.pdf

     ...

and then in the straight chart use the dimensions doc_id, doc_page and the expression:

'Open attachment<url>'&file_path

Also note to set expression representation to "link".

That should generate a chart showing all invoices, and the correct number of pages for each invoice together with a link to each page (each attachment). When opening the different attachments this way, they should open in the correct program (i.e. text-editor for .txt, image viewer for .jpg, pdf-reader for .pdf).

I hope I understood your question correctly, and that you'll find use for my answers.

BR

Jakob Berglund

[#3]

Great! This was excatly what I needed. I have a view containing invoice details

of one invoice at a time. Now the straight table is one of the datails and

living according to it how many attachments the invoice has.

A minor problem is that QlikView is asking "Approve application for launch"

for every attachment. Should ask only for the first one of each type of

attachnment (pdf, jpg, ...) or should ask not at all.

Thanks for rapid solution!

TT

[#4]

Glad to help!

About the "approve application for launch", I fear it is something that we'll have to live with. Hopefully in a coming update, there will be an option to disable such warnings, but as all request; the more people requesting, the more likely the implementation.

JB