topic Re: How to show files from SQL in QlikView table in QlikView

How to show files from SQL in QlikView table

Dayna — Tue, 20 May 2014 14:30:35 GMT

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

Re: How to show files from SQL in QlikView table

Tue, 20 May 2014 14:35:02 GMT

Image:

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

In chart use this expression: -

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

Re: How to show files from SQL in QlikView table

Dayna — Tue, 20 May 2014 14:45:11 GMT

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

Re: How to show files from SQL in QlikView table

Tue, 20 May 2014 14:48:32 GMT

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

Re: How to show files from SQL in QlikView table

Dayna — Tue, 20 May 2014 14:50:47 GMT

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.