Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Subfield with 3 columns simultaneously

Hi everyone, I'm new with QlikSense, I have this info:

Capturaa.PNG

I'm looking for this result:

Capturaa1.PNG

Can anybody help me?... I was trying with subfield function, but It doesn't work the way i want.

Labels (1)
3 Replies
Highlighted
Partner
Partner

Re: Subfield with 3 columns simultaneously

Hi,
I couldn't find a logical pattern to get the result you required.

Maybe you can share with us what is the logic to achieve your end result?
Highlighted
Contributor
Contributor

Re: Subfield with 3 columns simultaneously

There was a mistake. I've corrected the information.

I need it in order to search in another DB my clients connected to that infraestructure 

Highlighted
Specialist III
Specialist III

Re: Subfield with 3 columns simultaneously

I'm struggling to find a pattern in your requirements

It looks like there are differing requirements depending on whether your columns are delimited with a hyphen, a comma, or a semicolon ( - ,  ; ).

Using a semicolon I can get a good match for DISTRIB = 2000, but things fall apart with DISTRIB = 3000

See the image below for the partial solution I found.

Capture.PNG