topic Link to file in QlikView

Link to file

Tue, 10 Aug 2010 07:38:01 GMT

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.

Link to file

Tue, 10 Aug 2010 08:17:44 GMT

please take path string this manner

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

Regards

Ashish Srivastava

Link to file

Tue, 10 Aug 2010 08:33:34 GMT

I've tried:

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

Still the same problem with spaces...

Link to file

Tue, 10 Aug 2010 09:00:53 GMT

Hi;

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

I think you can find your solution

Good Luck

Link to file

Tue, 10 Aug 2010 09:32:26 GMT

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.

Link to file

raghavsurya — Tue, 10 Aug 2010 09:37:49 GMT

Hi,

Can you please share your sample application.

Regards,

Raghav

Link to file

Tue, 10 Aug 2010 10:24:37 GMT

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

Link to file

jonathandienst — Tue, 10 Aug 2010 11:33:13 GMT

Aldo

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

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

Jonathan

Link to file

Tue, 10 Aug 2010 11:59:22 GMT

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.

Link to file

jonathandienst — Tue, 10 Aug 2010 12:12:51 GMT

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

Link to file

Tue, 10 Aug 2010 12:24:08 GMT

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

Link to file

jonathandienst — Tue, 10 Aug 2010 16:35:40 GMT

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

Link to file

Sun, 23 Jan 2011 20:24:11 GMT

Link to file

Mon, 24 Jan 2011 09:59:42 GMT

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.

Link to file

Fri, 25 Nov 2011 16:13:38 GMT

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!