Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Conditional Show based on Chart Selection

I'm not very familiar with conditional show/hides, but I'm wondering if 'Chart Selection' can be a trigger event. I'm trying to only show a list box once the user has selected a specific sheet object. If it is possible could someone please help me with the syntax to put in the List Box's Conditional Show field on the Layout tab?

I'm using QV10 SR4.

Thank you!

Tags (1)
1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Conditional Show based on Chart Selection

In Qlikview vocabulary, word "select" referes to the values of a field.  E.g. you can select value 'Canada' in the field "Country".  You cannot "select" a sheet object.
But you can "activate" a sheet object.  And, there is a trigger "OnActivate" for Sheet Objects - see sheet properties, tab Triggers.  That means you can do the next:
First, create a variable, let's call it "ShowListbox". Next, in the list box properties, tab Layout, select Show radio-button "conditional", and the condition will be ShowListbox=1.
Last step, go to the sheet properties, tab Triggers, find object id of the chart you will be activating, and click button AddAction under OnActivate label.  click Add, External, choose action Aet Variable, click OK.  In Variable field type ShowListbox, and in value field type 1.
That's it.
Another question - waht is the trigger for hiding list box.  I hope you'll figure out :-)

Regards,
Michael

6 Replies
mov
Esteemed Contributor III

Conditional Show based on Chart Selection

In Qlikview vocabulary, word "select" referes to the values of a field.  E.g. you can select value 'Canada' in the field "Country".  You cannot "select" a sheet object.
But you can "activate" a sheet object.  And, there is a trigger "OnActivate" for Sheet Objects - see sheet properties, tab Triggers.  That means you can do the next:
First, create a variable, let's call it "ShowListbox". Next, in the list box properties, tab Layout, select Show radio-button "conditional", and the condition will be ShowListbox=1.
Last step, go to the sheet properties, tab Triggers, find object id of the chart you will be activating, and click button AddAction under OnActivate label.  click Add, External, choose action Aet Variable, click OK.  In Variable field type ShowListbox, and in value field type 1.
That's it.
Another question - waht is the trigger for hiding list box.  I hope you'll figure out :-)

Regards,
Michael

Conditional Show based on Chart Selection

Note that the OnActivate object trigger goes away in qv11.

Rob

Not applicable

Re: Conditional Show based on Chart Selection

Hi,

as the OnActivate object trigger has been removed from QV11, how would one trigger events based on if a chart is active? I would need to show conditionally a listbox if chart is active/open?

Tuomas

Not applicable

Re: Conditional Show based on Chart Selection

hi why has this trigger been removed becuase i would need it right now?? why things are being removed in qv11 I don't understand specially something like this

regards,

MT

Re: Conditional Show based on Chart Selection

I think it was removed because "Activate" as a trigger was confusing. What we really wanted was "OnClick", which is a trigger that doesn't exist (yet).

An object is Activated when it's clicked. But it's also Activated when it's lassoed. What should happen if three objects are lassoed and the associated Actions conclict with one another?

That's just my take on it. I'm ok with it going away. I hope we get an OnClick trigger to replace it.

-Rob

Not applicable

Re: Conditional Show based on Chart Selection

Wow - that is a really bad feature to take away.     Leave it up to the designer.   To me it is bad design if you design something with triggers that can be lassoed.    I need this feature badly!

Community Browser