Link to file

[#1]

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.

[#2]

I tried, but doesn't work..., but it seems to be the right direction to solve it...

[jonathandienst]

Aldo

Unless someone comes up with another idea, the only thing I can suggest is that the files are renamed to remove the spaces.

Jonathan

[#4]

Hi Stoney,

Your suggestion works fine, but I can not see the text in the post itself (only in the e-mail I received). Please re-publish your suggestion in order to mark it as "The answer".

Below the text I received by e-mail.

Thanks,

Aldo.

By Stoney Cook in QlikView Desktop (Developer/Professional/Analyzer)

Ran into the same problem.
This replace worked for me in the link expression.
=FileName & '<url>' & replace(FileName, ' ', chr(2)&'0')
A space is replaced by chr(2) which yields the ampersand % and then I just concat on an alpha zero "0".
In your example the resulting URL will read http://<url>/Picture%2001.jpg.
No need to alter filenames on your web server.

[#5]

I Appreciate this thread is a bit old now, but I have exactly this problem, but your solution doesn't work for me. I actually need the link to point to a file with a variable. 

I can get QV to open the application, but as soon as I try and pass the variable with the space involved then I get 'Failed to Launch', so I tried your solution above but chr(2) makes a very strange character.

So I can get this to run:

='Open in CRM<URL>'& 'C:\OpenCRM.vbs'

But not this:

='Open in CRM<URL>'& 'C:\OpenCRM.vbs '& [CLI]

nor this:

='Open in CRM<URL>'& replace('C:\OpenCRM.vbs ', ' ', chr(2)&'0') & [CLI]

Help!