Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kurakuaa
Contributor
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 

1 Solution

Accepted Solutions
olivierrobin
Specialist III
Specialist III

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
olivierrobin
Specialist III
Specialist III

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
Former Employee
Former Employee

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 do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
kurakuaa
Contributor
Contributor
Author

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
Specialist III
Specialist III

don't forget file://  before your URL

 

so something like

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

kurakuaa
Contributor
Contributor
Author

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
Contributor
Contributor
Author

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
Specialist III
Specialist III

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
Contributor
Contributor
Author

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

 

Thanks,

Avinash

olivierrobin
Specialist III
Specialist III

you're welcome