topic Re: Button Action: Clear all except Field in QlikView

Button Action: Clear all except Field

microwin88x — Fri, 14 Mar 2014 14:46:53 GMT

Hello!

Is there any way to use a Button with an action to clear all except the selections I have in a particular field?

Thank you!!!

Re: Button Action: Delete all except Field

Fri, 14 Mar 2014 14:51:04 GMT

Do you mean you want to clear all your selections except for one field? If that is the case, just add three actions to your button, the first should "Lock Field" Action under the Selection Action type and add the field you want to keep, then add an action to "Clear all", then add a third action to unlock the field.

Re: Button Action: Delete all except Field

PrashantSangle — Fri, 14 Mar 2014 14:56:26 GMT

Hi,

"delete all except the selections" means you want to delete from your database or listbox??

after clear selections you want that data back or delete permanently??

Re: Button Action: Clear all except Field

daveamz — Fri, 14 Mar 2014 14:59:56 GMT

Hi,

Use Action > Selection > Clear Other Field where Field= Except field

Best regards,

David

Re: Button Action: Clear all except Field

MK_QSL — Fri, 14 Mar 2014 15:01:36 GMT

Select any of your choice from your list box.

Go to selection menu and select Set Clear State

Now select other data from your list box.

do clear all.. you can see that your initial selection is still there.

Is this what you want?

Re: Button Action: Clear all except Field

Fri, 14 Mar 2014 15:01:43 GMT

Attached a sample doc with your requirement. Please look at the actions in the Button object. They are as mentioned by Grace.

It clears everything except a field called 'GP CC'

Thanks

Re: Button Action: Clear all except Field

MK_QSL — Fri, 14 Mar 2014 15:04:28 GMT

Through Button...

Create a button.

Go to Action Tab... >> Add >> Selection >> Clear All

Go to Action Tab....>> Add >> Select in Field >>

Field >> YourFieldName

Search String >> Your Field Value which you want to keep as default selection

i.e. Field >> Customer

Search String >> A

Re: Button Action: Clear all except Field

microwin88x — Fri, 14 Mar 2014 15:22:19 GMT

Thanks, it is useful, but I want to select multiple values for that field.

Should I use:

Select in Field:

Field: Category

Search: Cat1

Field: Category

Search: Cat2

Field: Category

Search: Cat3

Or is there any way to use

Field: Category

Search: Cat1, Cat2, Cat3?

Re: Button Action: Clear all except Field

microwin88x — Fri, 14 Mar 2014 15:24:39 GMT

Thanks for your help. But the thing is that if I make another selection for the field I want to clear, it always keeps me the last selection I made, and I want to always have a selection for values A, B and C, for example.

Re: Button Action: Clear all except Field

MK_QSL — Fri, 14 Mar 2014 15:25:39 GMT

(Cat1|Cat2|Cat3)

Re: Button Action: Clear all except Field

microwin88x — Fri, 14 Mar 2014 15:33:03 GMT

Thanks! And one of the field values has a space, for example: No Category

(Cat1|Cat2|Cat3|No Category)

In that case it doesn't select the last one

Edit: I believe it worked with (Cat1|Cat2|Cat3|"No Category")

Re: Button Action: Clear all except Field

Fri, 14 Mar 2014 15:37:27 GMT

Just use * to separate it so use Cat3|No*Category

Re: Button Action: Clear all except Field

qliknewby — Wed, 15 May 2024 20:03:20 GMT

Thanks, Daveamz! I used "Clear Field" and it works. I am now realizing that I may have designed it wrong. I have a list that I am showing as a button group. However, since it only displays the valid values for that field, I don't have a null to turn off any selections. Clearing the field selects the first option in the list (button group)

If I show the list as a dropdown and clear all, the dropdown is blank. Is there also a way to "clear all" for the list (as a button group) where no value is highlighted? Currently, "Clear All

Re: Button Action: Delete all except Field

qliknewby — Wed, 15 May 2024 20:09:19 GMT

Thanks! This works. I just cant seem to completely deselect the drop down (as a button group). This deselects my selected option, but default back to the first option in the list. I want all items to be unhighlighted.