topic Event Action (Text Object) in QlikView

Event Action (Text Object)

Tue, 20 Sep 2016 14:00:01 GMT

Hi,

I have a text object (being used as a RAG) which I would like to activate a chart on another sheet using event action whilst at the same time switching to aforementioned sheet which the object is clicked.

Switching to the sheet works OK but the chart remains inactive. I have tried both 'Activate Object' and 'Maximise Object' with both being the first action to do before the switch and also the last but the chart remains inactive. I could set a trigger on the other worksheet to open the report when the sheet is activated but I need all the reports minimised on each sheet as the User can view activate the sheets themselves.

Re: Event Action (Text Object)

Peter_Cammaert — Tue, 20 Sep 2016 16:17:50 GMT

What do you mean by "Activate a Chart on another Sheet"? Unhide? Maximize? Make the caption active (and change color)?

To unhide, let the text box set a variable, and use that variable as a flag in the Conditional Show expression of the chart.

Re: Event Action (Text Object)

Wed, 21 Sep 2016 07:07:52 GMT

Morning, I've managed to resolved the issue. I basically have a dashboard with Red, Amber Green Text Objects. These are determined by the results of a calculated base colour. What I wanted the user to click on a text object and redirect them to the underlying data in the report for further analyse.

As the charts for the data are in a container I have to order the actions to restore object for the container and restore object for the chart and then activate the sheet the are on.