topic Trigger to select a value on Clear in QlikView

Trigger to select a value on Clear

regowins — Wed, 03 Apr 2013 15:17:12 GMT

Hi,

Is it possible to create a trigger that selects a value in a field when the clear button is pressed?

Thanks!

Re: Trigger to select a value on Clear

Wed, 03 Apr 2013 16:16:16 GMT

Hi Ash,

Yes you can create.

Step1: Create a Button

Step2: Go to actions Tab Click on Add and select clear all

Step3: Now, Create another Action and this time select "Select in Field" and give default value in search string.

once done, when click on the created button it will clear and selects the field which you specified.

Hope this helps.

Re: Trigger to select a value on Clear

m_woolf — Wed, 03 Apr 2013 16:27:04 GMT

When I search the forum for Trigger on Clear, I find:

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

Re: Trigger to select a value on Clear

Gysbert_Wassenaar — Wed, 03 Apr 2013 16:41:46 GMT

Yes, you can use the OnAnySelect trigger and add a Select in Field action. Use an if statement to

check the length of the string getcurrentselections() returns. If the length is zero than all fields were cleared and you want to select a value. Something like if(len(getcurrentselections())=0, 'MyValue')