Link to a shared drive

[#1]

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

[Anonymous]

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'

[#3]

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.

[#4]

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.

[Anonymous]

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

[#6]

@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)

[Anonymous · Accepted solution]

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

[kurakuaa]

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