topic Re: Link to a shared drive in QlikView

Link to a shared drive

Tue, 17 Dec 2013 16:37:16 GMT

Hi,

I would like to include a column with hyperlinks. So, when you click on the cell not get the filtering but open a file in a shared drive location. How is that possible?

Thanks

Re: Link to a shared drive

Anonymous — Tue, 17 Dec 2013 16:47:08 GMT

Hi Electrical,

You can use straight table with expression using representation "Link" - see Expressions tab in the chart properties. Try for example an expression like this:

='calculator' & '<URL>' & 'calc.exe'

Re: Link to a shared drive

Tue, 17 Dec 2013 17:00:28 GMT

Thanks, I will try that. I used a table box and I have a question. If you turn it to a straight table, how can you put an expression just to show you all rows? Without having a unique ID in your data, but having let's say 2 fields combined as a unique identifier.

Re: Link to a shared drive

Tue, 17 Dec 2013 17:07:49 GMT

Hi Electrical,

You can use the Text Object or New Button Object, just add Action -> Action Type is -> External Action is ->Launch and add application path or file name, Working directory.

Re: Link to a shared drive

Anonymous — Tue, 17 Dec 2013 17:15:29 GMT

(I'm not sure I understand your question...)

If I guess correctly, just use both fields as dimensions. The will be a separate row for each unique combination of the dimensions.

Re: Link to a shared drive

Wed, 18 Dec 2013 10:18:13 GMT

@Michael,

You are right, that was simple. I had something else in mind concerning count.

I don't want a button or a text object. I tried the link solution and it gets a little confusing.

If you put = '<URL>' & [Link Column] it works and opens the file. But it shows nothing (!!) in the cell and even worse, when you turn to web mode it acts as a normal text cell (i.e. filters when you click)

Re: Link to a shared drive

Anonymous — Wed, 18 Dec 2013 16:27:27 GMT

ElectricalEng,

I see two issues here.

The first one, the empty cells, is simple. The cell shows the text calculated before the URL tag. In my example

='calculator' & '<URL>' & 'calc.exe'

the text is 'calculator'. Typically it is to show something more meaningful and based on the dimension(s) for example name:

=UserName & '<URL>' & 'a URL to LinkdIn profile of this user'

Second issue is about the web view.

If it is a URL , like this

http://community.qlik.com

or this

'http://community.qlik.com/message/438229?et=watches.email.thread#' & ThreadNumber

it works fine in web view on or off.

If it is a file on a shared drive, you can use UNC format:

\\server\share\file_path\file_name

Regards,

Michael

Re: Link to a shared drive

kurakuaa — Wed, 30 Oct 2019 15:57:54 GMT

Hi Michael,

I have requirement like to open many different files from one shared path in Pivot table. Could please help me on the below table requirement how to show link on shared path in chart.

ID	File Seq	Shared Path
1	1	\\Files\open\A.doc
1	2	\\Files\open\B.Pdf
1	3	\\Files\open\AB.xps
2	1	\\Files\open\C.doc
2	2	\\Files\open\D.doc
3	1	\\Files\open\E.Pdf

So for this shared path for every user has access to open shared path to view the files.

Can you please help me in how to write expression to get link on shared path for the expression.

Thanks in Advance.

Thanks,

Avinash