Qlik Community

New to Qlik Sense

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

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Lian
Contributor
Contributor

Show all values from a string with multiple values

Hello everyone,

I'm trying to make a clear table with error codes. The error codes are in a string of text. I manage to filter out the error code and only display that code, but sometimes there are several error codes in one string. At the moment that string is only displayed for the error code I mentioned first in my query.
How can I display this string with all the error codes it contains?

To clarify, here's an example of one string:

String
emergency stop E001, E206 detection failed, not enough pressure E080.

I tried to make a query with Pick an Wildmatch.
PICK(WILDMATCH([Field], '*E001*', '*E002*', etc.), 'E001', 'E002', etc.)

This works reasonably well, but only for strings with only 1 error code. In the example above, the output is as follows:
E001         emergency stop E001, E206 detection failed, not enough pressure E080.

But I want this output:
E001         emergency stop E001, E206 detection failed, not enough pressure E080.
E206         emergency stop E001, E206 detection failed, not enough pressure E080.
E080         emergency stop E001, E206 detection failed, not enough pressure E080.

How can I solve this? Can someone help me?

0 Replies