Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
asa_runstrom
New Contributor III

Button exklude two value

Hi

I have list with id and I try to build a button that exklude two of the ids. I manage to exklude one but not two. Hows should I write the code?

Tags (2)
1 Solution

Accepted Solutions
yashdeep
New Contributor III

Re: Button exklude two value

step 1 : add  'Select in Field' action and put (ID1|ID2) in expression

step 2 : add 'Select Excluded' action to the same button

this will solve your problem.

3 Replies
shiveshsingh
Honored Contributor

Re: Button exklude two value

What is the expression that your are using in button actions?

May be you can concat both the ids

= '(' & Concat({< ID-= {'ID1', 'ID2'} >}ID, '|') & ')'

MVP
MVP

Re: Button exklude two value

For multiple values, you could use search string with values separated by pipe symbol. Try like"

=( ID1 | ID2)

yashdeep
New Contributor III

Re: Button exklude two value

step 1 : add  'Select in Field' action and put (ID1|ID2) in expression

step 2 : add 'Select Excluded' action to the same button

this will solve your problem.