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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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