Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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