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]

Hi

please take path string this manner

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

Regards

Ashish Srivastava

[#3]

I've tried:

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

Still the same problem with spaces...

[#4]

Hi;

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

I think you can find your solution

Good Luck

[#5]

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]

Hi,

Can you please share your sample application.

Regards,

Raghav

[#7]

[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]

Aldo

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

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

Jonathan

[#9]

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]

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