topic Re: Clearing multiple fields in one trigger in QlikView

Clearing multiple fields in one trigger

zagzebski — Tue, 02 Jun 2015 18:27:52 GMT

I have a few buttons where I clear multiple fields from the same table. However I always have to do it one by one using the "Clear Field" option. Is there a way to clear multiple fields in one step? (Note: I don't want to clear all fields)

Steve

Re: Clearing multiple fields in one trigger

ankit777 — Wed, 03 Jun 2015 10:48:44 GMT

Hi,

add a button and add multiple clear filed actions on it , for each field you want to clear.

Re: Clearing multiple fields in one trigger

PrashantSangle — Wed, 03 Jun 2015 10:51:14 GMT

Use Clear All Trigger.

Regards

Re: Clearing multiple fields in one trigger

zagzebski — Wed, 03 Jun 2015 11:58:22 GMT

Thanks for the response. I realize I can do that but isn't there a way to clear more than one field in one action instead of having to enter multiple actins each time?

Re: Clearing multiple fields in one trigger

zagzebski — Wed, 03 Jun 2015 12:00:47 GMT

Max - I don't wanrt to clear everything, but I do want to make sure all calendar fields are cleared. Isn't therte a way (in one action) that you can celar multiple fields or all fields from a specific table - without having to do a separate clear field action for every field. For instance my calaendar table has 20 fields - do I have to have 20 different clear field actions??

Re: Clearing multiple fields in one trigger

ankit777 — Wed, 03 Jun 2015 12:03:07 GMT

I think one action will clear one field only

Re: Clearing multiple fields in one trigger

stigchel — Wed, 03 Jun 2015 12:28:23 GMT

You can use something in set analysis to exclude all the calendar selections

Set vClearCalendar = "='[' & Concat({1<$Table={'Calendar'}>} $Field, ']=,[') & ']=' ";

Sum ({$<$(vClearCalendar)>} Amount)

Another work around is to create a table box, and bring all fields you want to clear. In the table box caption, add "clear" icon. When you click it, only the fields of this table are cleared.

Re: Clearing multiple fields in one trigger

Anonymous — Thu, 01 Oct 2015 06:16:42 GMT

Hi Zagzebski,

I don't know if I am too late in giving a response to your question, but I thought someone else might benefit from this.

I have the same issue where I had to hide all the fields having the name "Total" using a single button and a single action and I am using a straight table.So what I did is I took a set variable option in button actions and varible value as "vTotal" and value as:

=if(vTotal=1,0,1)

Then I applied the variable "vTotal" in the expressions which I want to hide under the conditional text box and now it works fine for me.

I am posting this reply so that it might help somebody like it did to me.

Thanks,

Re: Clearing multiple fields in one trigger

Fri, 18 Dec 2015 20:07:49 GMT

Just add multiple "Clear Field" actions within the individual button's properties. Then just select one field you'd like to clear within each action.

Re: Clearing multiple fields in one trigger

Fri, 18 Dec 2015 20:16:53 GMT

you can have a single button that performs multiple clears. You would need to add an action for each field you want to clear in one button or text box - when you then click the object, all of the fields you wanted to ahve cleared, should be cleared

Re: Clearing multiple fields in one trigger

marcus_sommer — Sat, 19 Dec 2015 00:44:29 GMT

Maybe you could use a reversed logic by applying a selection to these calencar-fields with a search-expression like: =null() which has the same effect like a clear-action and then you put those selections for all of your calendar-fields into a bookmark which will be applied on top to the other selections. And then you called this bookmark-action with your button.

- Marcus

Re: Clearing multiple fields in one trigger

Anonymous — Fri, 04 Mar 2016 12:22:06 GMT

You can create a variable, let's say vClearFields, create a trigger on this vClearFields variable input action. Set all the fields that you want to clear in that trigger's action. Now, wherever you want to clear all those fields, you just need to set some value(whatever could be value, whatever times you want to assign) to that variable, which will provoke that trigger and it will clear all the required fields that you want to clear.

To cut it short, this will prevent you from not writing clear fields all the time where you want to clear those fields. You just need to set some value to variable and that'll clear selected fields.

Hope this helps !