Solved: Re: Conditional Show based on Chart Selection - Qlik Community

Report Inappropriate Content · ‎2012-03-13

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!

Anonymous · ‎2012-03-13

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

View solution in original post

Anonymous · ‎2012-03-13

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

rwunderlich · ‎2012-03-13

Note that the OnActivate object trigger goes away in qv11.

Rob

Report Inappropriate Content · ‎2012-10-30

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

Report Inappropriate Content · ‎2012-11-29

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

rwunderlich · ‎2012-11-29

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

Report Inappropriate Content · ‎2015-03-13

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!