Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
davidargz
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
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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?
davidargz
Contributor
Contributor
Author

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 

marcus_malinow
Partner - Specialist III
Partner - Specialist III

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