Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
kurakuaa
New Contributor

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

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

IDFiles 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 

Tags (1)
1 Solution

Accepted Solutions
Highlighted
olivierrobin
Valued Contributor III

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

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 ?

View solution in original post

9 Replies
Highlighted
olivierrobin
Valued Contributor III

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

hello

the expression for a clicable link shouls begin with

<url>http://

 

in your cas, I would try

<url>file: concatenated with your link

Highlighted
Digital Support
Digital Support

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

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Highlighted
kurakuaa
New Contributor

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

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

Highlighted
olivierrobin
Valued Contributor III

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

don't forget file://  before your URL

 

so something like

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

Highlighted
kurakuaa
New Contributor

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

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

Highlighted
kurakuaa
New Contributor

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

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

Highlighted
olivierrobin
Valued Contributor III

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

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 ?

View solution in original post

kurakuaa
New Contributor

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

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

 

Thanks,

Avinash

Highlighted
olivierrobin
Valued Contributor III

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

you're welcome