topic Re: Button exklude two value in QlikView

Button exklude two value

asa_runstrom — Fri, 01 Jun 2018 09:34:40 GMT

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?

shiveshsingh — Fri, 01 Jun 2018 09:40:10 GMT

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

May be you can concat both the ids

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

tresB — Fri, 01 Jun 2018 09:58:39 GMT

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

=( ID1 | ID2)

yashdeep — Fri, 01 Jun 2018 10:15:09 GMT

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.