Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Button selection of an list of values into field

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
mov
Esteemed Contributor III

Re: Button selection of an list of values into field

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

Re: Button selection of an list of values into field

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

mov
Esteemed Contributor III

Re: Button selection of an list of values into field

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

rustyfishbones
Honored Contributor II

Re: Button selection of an list of values into field

hi this video may help

It shows 5 ways to Select in Field

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

Community Browser