Qlik Community

Qlik Sense App Development

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

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
New Contributor

Subfield with 3 columns simultaneously

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


I'm looking for this result:


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

Labels (1)
3 Replies

Re: Subfield with 3 columns simultaneously

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?
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 

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.