topic onclear event exist? in QlikView

onclear event exist?

niceqlik — Wed, 22 Jul 2009 15:04:22 GMT

hi all,

i need to trigger a macro when i clear all selections. in document properties -> triggers - > document event triggers , there is no onClear trigger defined.

i know there is an option that i can create a button that function both for clearing the fields and running my macro respectively. but i do not want to use it this way. i have specifically a need for onclear event?

how can it be possible?

thanks.

qv developer version : 9.0

onclear event exist?

kji — Wed, 22 Jul 2009 15:41:35 GMT

Clear is counted as a selection, so the OnAnySelect will be triggered.

onclear event exist?

Sat, 01 Aug 2009 02:23:27 GMT

This doesn't work. Clear does not trigger the document OnAnySelect Trigger. Is there any other options?

onclear event exist?

Anonymous — Sat, 01 Aug 2009 03:42:04 GMT

It is possible by using a separate field (logical island) which is always selected except when you use Clear. The change in this field will be your "onclear event".

onclear event exist?

Sat, 01 Aug 2009 03:50:21 GMT

I tried that and here is what i found, There are issues using a % or "user defined system field" and there are issues using fields that have spaces. I renamed the field to daterangefix from %Date Range and I created an onchange trigger on a key that noone will select.