Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Partner - Master
Partner - Master

Select multiple values in a field, not working for integers


I'm using the 'Button for navigation' from Qlik Sense (November 2019 Patch 2). Here I'm using the function, 'select multiple values in a field'. This seems to work with values that are presented as text. The Field Item-Color has for example:

  • 3091750123
  • 2057123012
  • 120A120-10293
  • 140B102-12811



I've created a function that is removing/replacing unwanted characters (hyphen,  - is allowed). The rest is replaced with a ; which is the delimiter.



The input box is used to fill the variable:




The problem occurs when I want to search for integers. When that is done, the values are not passed through as a selection. When one of the values is a text value, the value is passed through as a selection..

  • 3091750123
  • 2057123012
  • Outcome -> No selection
  • 120A120-10293
  • 140B102-12811
  • Outcome -> Both values
  • 2057123012
  • 120A120-10293
  • 140B102-12811
  • Outcome -> Only the last two values not the integer

What have I tried?

  • Making all values text values in the script
  • Making the values text values in the formula


If someone knows how to fix this.. please




Work smarter, not harder
Labels (4)
0 Replies