Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
please take path string this manner
C:\[Documents and Settings]\aldo\Desktop\[Picture 01].jpg
Regards
Ashish Srivastava
I've tried:
FileName & '<url>' & 'C:\Temp\[Picture 01].jpg'
Still the same problem with spaces...
Hi;
You can find an example in QV 9 in getting started 'Example Start Page'
I think you can find your solution
Good Luck
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.
Hi,
Can you please share your sample application.
Regards,
Raghav
[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.
Aldo
Did you try %20 (url encoding) for the space:
ie C:\Documents and Settings\aldo\Desktop\ Picture%2001.jpg
Jonathan
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.
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