Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Link to file

Hi Guys,

I need to create a table or pivot table having:

File name in the first column,

clickeable link to open the file (Excel, Word, etc) in the second column.

I tried creating a table with filename as dimension and full path as Expression.

The expression (represented as a link) is:

=FileName & '<url>' & FullName

where for example

FileName = Picture 01

FullName = C:\Documents and Settings\aldo\Desktop\ Picture 01.jpg

When clicking on the link, QV gives me the following error message: "Failed to launch C:\Documents+and+Settings\aldo\Desktop\Picture+01.jpg "

Please note that QV replaced space characters by '+' char.

I tried with a link with no spaces in the name, such as: "C:\Temp\Picture_01.jpg" and it works…

What should I change in order to make it work?

Thanks in advance,

Aldo.



14 Replies
Not applicable
Author

Hi

please take path string this manner

C:\[Documents and Settings]\aldo\Desktop\[Picture 01].jpg

Regards

Ashish Srivastava

Not applicable
Author

I've tried:

FileName & '<url>' & 'C:\Temp\[Picture 01].jpg'

Still the same problem with spaces...

Not applicable
Author

Hi;

You can find an example in QV 9 in getting started 'Example Start Page'

I think you can find your solution

Good Luck

Not applicable
Author

You are right, that is a possible solution. I tried and works, but it uses a Button.

I'd like to put the link to the file as a column in the table... is there any way to do it?

Thanks in advance,

Aldo.

raghavsurya
Partner - Specialist
Partner - Specialist

Hi,

Can you please share your sample application.

Regards,

Raghav

Not applicable
Author

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.02.89.41/Link-To-File-2010081000.qvw]

See the attachment.

Aldo.

jonathandienst
Partner - Champion III
Partner - Champion III

Aldo

Did you try %20 (url encoding) for the space:

ie C:\Documents and Settings\aldo\Desktop\ Picture%2001.jpg

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Excellent suggestion!

How do I implement it?

I tried: FileName & '<url>' & 'C:\Temp\BKS%20Flyer%2001.jpg'

I also tried: FileName & '<url>' & 'C:\Temp\BKS+%20+Flyer+%20+01.jpg'

Thanks,

Aldo.

jonathandienst
Partner - Champion III
Partner - Champion III

Aldo

Haven't tried this myself. But you would not need + signs for the URL encoding. %20 is hex 0x20 (decimal 32, ASCII space).

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein