Unable to create URL link for shared path location in Qlikview chart expression

[kurakuaa]

Hi All,

Below is table my requirement and I want to view shared path location files in URL link and when I hit that link documents like PDF, DOC etc needs to be open on Qlikview chart selection

ID	Files Path
1	\\Location\files\A.pdf
1	\\Location\files\B.pdf
1	\\Location\files\C.pdf
2	\\Location\files\D.doc
2	\\Location\files\e.doc

I have taken ID as dimension and files path as expression in Qlikview chart. For files path expression I have given "Link" as representation also but still URL is not displaying.

FYI...... Files path column is created in SQL database as varchar format. All users has access to shared path to view files.

Thanks in Advance.

Thanks,

Avinash 

[olivierrobin]

hello

the expression for a clicable link shouls begin with

<url>http://

in your cas, I would try

<url>file: concatenated with your link

[Brett_Bleess]

Did Olivier's post help you get things working?  If so, do not forget to use the Accept as Solution button on his post to give him credit and let others know the post helped you get things working.  If you still require further assistance, please leave an update, and if you did do something else, consider posting that, and then use the solution button on that post.

Regards,
Brett

[kurakuaa]

Hi,

Many thanks for your reply,

Can you please write expression for the above table. I am not getting output for your message in my chart, it is showing empty.

I tried two ways with representation as Link in chart expression

=Fieldname  &'<URL>'&  Fieldname

='<URL>'& Fieldname

Please help me on this

Thanks,

Avinash

[olivierrobin]

don't forget file://  before your URL

so something like

='<URL>file://'& Fieldname

[kurakuaa]

Hi,

I tried above expression in the Straight table and Pivot table with representation as a Link, but expression is showing empty.

I have tested in web view mode on and off also, it is not working. FYI..... this column data in database in varchar format.

Please help me on this.

Thanks,

Avinash

[kurakuaa]

Hi,

When I try with action as open url in text object with above expression it is working fine and I am able to open the files.

I need that output in Straight table expression with representation as Link.

Thanks,

Avinash

[olivierrobin · Accepted solution]

heres is what i have (capture_chart)

and what i put in expression (capture_expression)

couls youy creat a sample .qvw with just a piece of dat and the chart ?

[kurakuaa]

Thank you so much for all your help. Now it is working in Chart expression.

Thanks,

Avinash

[olivierrobin]

you're welcome