Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
davidargz
New 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
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?
davidargz
New 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 

marcus_malinow
Valued Contributor 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