Macro to take user to one sheet from another

[#1]

Hi Community!

I want to create an input box, where the user either selects from a drop-down or manually enters a value. Upon entering this value(or selecting the value from a list of values), the user should be redirected to another sheet in the Qlikview document with a field called product name = the value entered.

I know it can be done through using a listbox and triggers on fields, but I cant use it. The problem with using a field trigger is that even when the user selects the field in another object, he would be redirected to the second sheet while I want it to happen ONLY with this input box.

Is it possible?

Thanks,

Nihar

[Gysbert_Wassenaar]

You'll have the same problem with a macro. There is no click event that can start a macro. So you need a trigger or a button to start the macro. And if you use a button you might as well use actions instead of a macro. As a workaround you could put a transparent text box over (the part of) the chart where users shouldn't be able to click in.

[#3]

Thanks Gysbert. Its a helpful answer..