Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add links to sheets in charts

I am looking for suggestions and information on how to add a link in a chart or even a specific field in a chart that would jump to another sheet in the QVW. Is something like this possible and if so, how can it be accomplished. Thanks!

4 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

You can accomplish it by using any objects or events that can trigger an action. For example:

- a transparent button that's positioned on top of the chart (or some portion of the chart) that triggers an action

- A selection in a field that triggers an action

Unfortunately, there are no Chart elements that can be directly linked to an Action - for example, you can't trigger an action when you click on a specific cell... So, you'll need to use work around solutions like those that I brought up earlier...

Not applicable
Author

I assume these actions are those that are only available with version 9. We are currently still on version 8.5, at least until a few months after version 10 is released. Can this be accomplised with this older version?

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Well, in the oder versions you'd have to use VBScript/JScript Macros to accomplish the same, and those are less attractive as a solution, from a variety of different perspectives...

In anticipation of the coming upgrade, I'd recommend delaying this particular feature till you can upgrade to the newer version. The alternative is very time-consuming, proven to hurt performance, and all the work will be thrown away after the upgrade...

Not applicable
Author

Hi

You Can use macro for this if u r using version 8.5.

Please define this macro,change the sheet no as your requirement.

sub Test
ActiveDocument.Sheets("SH03").Activate
end sub

please go to the following steps:-

1.Go to the setting >>Document properties >> Trigger

2. Go to field you want to event trigger >> click "on select" >> call the macro defined

Regards,

Ravi