topic Re: Creating Links in Chart in QlikView

Creating Links in Chart

Wed, 06 Nov 2013 16:55:58 GMT

Hello

Pivot table chart provides us a way to set an expression as a link (under Display Options > Represenation)

Is there any way I can add an action to this link and navigate to different sheet when clicked on this link?

Thanks

Re: Creating Links in Chart

rustyfishbones — Wed, 06 Nov 2013 17:11:38 GMT

No, Representaion link would be used if you had an expression like below

='Google'&'<URL>'&'http://www.google.com/search?q='

the result would look like this

Re: Creating Links in Chart

Gysbert_Wassenaar — Wed, 06 Nov 2013 17:14:53 GMT

You need an expression that creates a special crafted string that will function as a hyperlink. The expression looks like:

'Google' &'<url>www.google.com'. If displayed as link it will show Google. If you click on it you'll be send to www.google.com. The <url> part is the magic bit. Suppose you have two fields that contain a label, i.e. SiteName, and an url, i.e. Url. You can then use an expression like =[SiteName] & '<url>' & [URL] to construct the link strings.

Re: Creating Links in Chart

jonasheisterkam — Wed, 06 Nov 2013 18:12:07 GMT

If you use AJAX, the link can point to the opendoc.htm with a select param and the same document. Then you can react with a action on the selection, to change the sheet. I think the link is open in new window/tab, so you have a old disconnected session in the old tab and a new tab with the sheet you want to open.

Re: Creating Links in Chart

jonasheisterkam — Wed, 06 Nov 2013 18:32:12 GMT

If you will open a sheet without a real link, you can use changes on var or fields triggered by selection in chart.

Re: Creating Links in Chart

Thu, 07 Nov 2013 09:41:13 GMT

Is it possible to navigate to another sheet and pass parameters with above solution?

Thanks

Re: Creating Links in Chart

cbaqir — Fri, 02 Dec 2016 16:05:32 GMT

Is there a way to force the link to open in a new tab in the same window (instance) of the browser in IE? Right now it opens in a new window.

Re: Creating Links in Chart

Gysbert_Wassenaar — Fri, 02 Dec 2016 16:56:21 GMT

That's up to your browser. If your browser has a setting to open links in new tabs then you can enable that.

Re: Creating Links in Chart

Ethel — Fri, 14 Oct 2022 16:22:38 GMT

Hello, I know it's a long time since this theme has been discussed. I'm trying to do it in qlik sense and unfortunately expression ='Google'&'<URL>'&'http://www.google.com/search?q=' is not working for me. Maybe some other ideas or modifications how it should look like in qlik sense? I'm trying to add links to the footnote of the charts.

Thank you very much in advance!