topic Re: Cell section triggering an action in QlikView

Cell section triggering an action

simongoodman — Wed, 22 May 2013 14:36:41 GMT

Is there a way for a user to select a cell that is created by an expression in one pivot table that not only runs the filters but also performs a go to action into another pivot table? The selection would involve a date dimension and a type dimension.

I can see in Buttons under Action/Action Type 'Activate Sheet' and 'Select in Field' but neither seems appropriate. Any ideas?

Re: Cell section triggering an action

Gysbert_Wassenaar — Wed, 22 May 2013 14:48:55 GMT

That's not possible. Cells in tables (or the tables themselves) don't have click events that can be used to trigger actions. You can try using the OnAnySelect document trigger to catch changes in selections and trigger an action like setting a variable. The variable could be used to show/hide one or more chart objects using the Conditional expression option on the layout tab of properties window of the object.

Re: Cell section triggering an action

simongoodman — Wed, 22 May 2013 15:03:04 GMT

I wondered if that was the case. I know it is a bit cheeky but did you have

an example I could look that would show/hide multiple chart objects. Many

thanks.

On Wed, May 22, 2013 at 3:48 PM, Gysbert Wassenaar <qcwebmaster@qlik.com