Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Button selection of an list of values into field

Hello everybody,

i met some problem in order to create an button wich will make an selection into an field  of an list of values (all values  except two values )

For example i have an field Author wih a lots of values :

Author :

{A,B,C,D, etc...,Z}

and i would like by an action the selection of all the values  except  two values Y and Z

So the selection will be

{A,B,C,....., W,X}

if somebody could help me....

Thanks

5 Replies
Gysbert_Wassenaar

Simply select Y and Z first in a listbox and then right click the listbox and choose Excluded Values. No need for a button. If you feel you must do it with a button add two actions. The first a Select in Field action with as search string (Y|Z). The second a Select Excluded action.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

You can use button with these two actions:

1. Select in Field, field is Author, search string is *
2. Toggle Select, field is Author, search string is (Y|Z)

Regards,
Michael

Not applicable
Author

ok thanks a lot...

i understand what you mean but i ve an problem with the syntax i think

For the first action i only write in the field box the name of Autor and is working

But For the second action i don 't succed in searching the two values ...

I ve just only an filed case into write...

How do you write the search string is (Y/Z)

thank

Anonymous
Not applicable
Author

it is not (Y/Z), it is (Y|Z), look carefully 🙂

rustyfishbones
Master II
Master II

hi this video may help

It shows 5 ways to Select in Field

https://www.youtube.com/watch?v=URITSznaPA4