topic Re: how can make a trigger for clean a list box in QlikView

how can make a trigger for clean a list box

Wed, 21 Jan 2015 18:24:30 GMT

Hi Experts,

I have two list boxes and I want to clean one list box depending of the selection of other list box.

somebody can help me.

best regards.

Re: how can make a trigger for clean a list box

Anonymous — Wed, 21 Jan 2015 19:24:47 GMT

Hi,

you can set a Field Event trigger (Document properties>Tirggers) "On select" for the field of the second list box. The action wil be "Clear Field" in which you will set the field of the first list box.

Let me know if it's not clear!

Re: how can make a trigger for clean a list box

Anonymous — Wed, 21 Jan 2015 19:39:57 GMT

You can use the Document Properties -> Triggers -> Field Event Triggers -> OnSelect -> and any of the actions available.

http://community.qlik.com/message/193568#193568

Thanks

Re: how can make a trigger for clean a list box

Wed, 21 Jan 2015 19:50:31 GMT

Hi Elena thaks for your answer,

in fact I do that but it doesn't work because the field that must clear the list box must be in an specific value.

any idea?

Regards

Re: how can make a trigger for clean a list box

Wed, 21 Jan 2015 20:14:50 GMT

for example in attached file I want to clean _Account list box when _CustomReport have selected 'Budget' value

Best Regards.

Re: how can make a trigger for clean a list box

sunny_talwar — Wed, 21 Jan 2015 20:33:39 GMT

So only if Budget is selected it clears out _Account? or does it clear out on any selection in _CustomReport listbox?

Re: how can make a trigger for clean a list box

Wed, 21 Jan 2015 20:38:22 GMT

yes only if 'Budget' value is selected.

Best Regards.

Re: how can make a trigger for clean a list box

Anonymous — Wed, 21 Jan 2015 20:41:26 GMT

Hi,

You can try with the link i have posted .It might help you

Re: how can make a trigger for clean a list box

sunny_talwar — Wed, 21 Jan 2015 20:45:48 GMT

Is this what you are looking for? PFA

Best,

Re: how can make a trigger for clean a list box

Wed, 21 Jan 2015 20:53:31 GMT

thanks rgv rand in fact I checked but the problema here is that , when I tried to configure some condition in the part of 'ON SELECT' it not Works , I mean if I put only the field that most be cleaned it Works but when I put some 'IF' statement then it doesn't work.

and why and 'IF' statement, because only want to clean the list box when some value be selected ,I mean not in all selections of the same field.

best regards.

Re: how can make a trigger for clean a list box

sunny_talwar — Wed, 21 Jan 2015 20:55:00 GMT

Did you look at the qvw file I have attached? It might be doing what you want it to do.

Best,

Re: how can make a trigger for clean a list box

Wed, 21 Jan 2015 20:58:28 GMT

yes that's correct.

thanks a lot suindia.

Re: how can make a trigger for clean a list box

sunny_talwar — Wed, 21 Jan 2015 20:59:31 GMT

Your very welcome.

Best,

Re: how can make a trigger for clean a list box

Anonymous — Wed, 21 Jan 2015 21:01:22 GMT

Hi ,

i am using personal edition i couldn't open the qvw .Can u please post the code or explain brief what you did ?

Thnanks

Re: how can make a trigger for clean a list box

sunny_talwar — Wed, 21 Jan 2015 21:05:31 GMT

Trigger on _Custom Report:

Action is Select in Field, where Field is _Account only when _CustomerReport = 'Budget' and Search String is ''

Hope this helps.

Best,