How to show files from SQL in QlikView table

[Dayna]

Hello All!

I have a SQL table used to store PDF's, and I'd like to provide users a link within a QlikView table to view/download the file. I know it's possible to create links to sites or files within a network share by changing the representation to 'link' within a straight table.

Could anyone advise how to provide a link to the PDF? I've attached the binary that's outputed when I load from the SQL table in QlikView..

Kind Regards,

Dayna

[#2]

Image:

LOAD * INLINE [
SalarySlip
C:\Users\felim_shanaghy\Desktop\IMAGES\Wageslip.gif
];

In chart use this expression: -

  'Regular Salary' & '<url>' & SalarySlip

[Dayna]

I've tried 'URL'&Document with no joy... Would it work with what I've attached? As that's the output from SQL.

[#4]

The output looks scrambled, can it be represented in a URL form or are you attempting to load it into Qlikview using Bundle Load?

[Dayna]

There's no URL to load, the file itself is stored within a table in SQL - the load brings back a list of all the files stored.

In web apps and methods, it prompts the user with the file - just not sure how to do this in QlikView.