topic Re: Add an Action / Trigger to an Object in QlikView

Add an Action / Trigger to an Object

danielle_v — Mon, 18 Mar 2013 16:23:12 GMT

Hi All,

I'm not sure if this is possible, but what I'd like to do is to assign a trigger to a specific object (a bar chart) so that if a selection is made within this chart, a different sheet is activated.

I can't assign a trigger to the field, as I have a list box on the sheet containing the field in question, and I don't want to activate another sheet if a selection is made from the list box.... only if the selection is made within the bar chart.

Any suggestions would be hugely appreciated!

Thanks,

Danielle

Re: Add an Action / Trigger to an Object

Anonymous — Mon, 18 Mar 2013 16:36:24 GMT

Danielle,

Try to implement trigger by the field, but with an additional condition that the chart is active. Not sure if it is possible without macro.

Regards,

Michael

Re: Add an Action / Trigger to an Object

Anonymous — Mon, 18 Mar 2013 16:40:10 GMT

Hi,

A simple way to do this would be to duplicate the column in your data model...... e.g.

Table:

Load

b as b1

From.........

Then you can use the "new" (in this instance b1) column in your chart then assign the trigger to that column.

Cheers.

ABY.

Re: Add an Action / Trigger to an Object

danielle_v — Tue, 19 Mar 2013 10:31:08 GMT

Thank you both for your suggestions!

I actually went for Adam's suggestion and it worked perfectly - such a simple idea, but one I never would have thought of!

Thanks again!