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

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

kurakuaa — Sat, 16 Nov 2024 02:10:37 GMT

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

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

olivierrobin — Thu, 24 Oct 2019 15:37:55 GMT

hello

the expression for a clicable link shouls begin with

<url>http://

in your cas, I would try

<url>file: concatenated with your link

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

Brett_Bleess — Wed, 30 Oct 2019 14:59:11 GMT

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

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

kurakuaa — Wed, 30 Oct 2019 16:07:40 GMT

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

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

olivierrobin — Wed, 30 Oct 2019 16:35:31 GMT

don't forget file:// before your URL

so something like

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

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

kurakuaa — Thu, 31 Oct 2019 09:51:04 GMT

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

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

kurakuaa — Thu, 31 Oct 2019 12:42:20 GMT

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

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

olivierrobin — Thu, 31 Oct 2019 12:48:09 GMT

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 ?

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

kurakuaa — Thu, 31 Oct 2019 15:51:02 GMT

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

Thanks,

Avinash

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

olivierrobin — Thu, 31 Oct 2019 15:55:12 GMT

you're welcome