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

Multiple values in Toggle Field Selection Action

I have a button against which I wish to Add an Action to Toggle the Field Selection of the field Product Code so that it filters by codes 751675, 753399, and 892964 (or removes them when toggled off again).

I have selected my field and tried many combinations including the following for the value but none of them work 

  1. ('751675','753399','892964')
  2. ("751675","753399","892964")
  3. ('751675'|'753399'|'892964')
  4. ("751675"|"753399"|"892964")
  5. ('751675')& ('753399')& ('892964')

Can anyone please advise? Thankyou.

Labels (3)
5 Replies
PedroNetto
Partner - Creator
Partner - Creator

Hi @KJM 

Try:  '751675';'753399';'892964'

KJM
Contributor III
Contributor III
Author

Hi @PedroNetto 

 

This gives anerror:

Error in Expression: garbage after expression ';'

PedroNetto
Partner - Creator
Partner - Creator

Worked for me

Try:  ('751675'|'753399'|'892964')

KJM
Contributor III
Contributor III
Author

Weird, now giving an error:

 

Error in Expression:  ')' expected

 

But I definitely had the brackets closed.

vinieme12
Champion III
Champion III

As @PedroNetto  suggested ,this should work, ignore the error in the expression editor and try it

=('751675'|'753399'|'892964')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.