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.

cancel
Showing results for 
Search instead for 
Did you mean: 
ClementByr
Contributor III
Contributor III

Make a selection based of a chain of character

Hello,

I  want to select some string in selection box based on specific chain of character.

For example, in the selection box INSTRUCTION, I want to select all the string that have the value DISCRET in the string.

INSTRUCTION
DISCRET test
test|DISCRET|test
test

 

If I type on the research bar DISCRET or *DISCRET*, Qlik will only select the first row "DISCRET test" and not the second row "test|DISCRET|test". I need an input to get both of them.

Can you please help me ?

Best regard.

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

Seems to have worked for me

image.png

View solution in original post

4 Replies
sunny_talwar

I believe *DISCRET* should select both the first and the second row... will test it out in a dummy sample now.

sunny_talwar

Seems to have worked for me

image.png

ClementByr
Contributor III
Contributor III
Author

Hello Sunny,

I work with a lot of data using remote connexion from home. The connexion is slow so the data take some time to load.

When I have typed "*DISCRET*", I saw that no result have been found. I through it did not work.

But now, I have waited a bit and it work.

Thank you for confirming the formula.

Best regard.

sunny_talwar

No worries. I am glad it worked.