topic Re: Subfield with 3 columns simultaneously in App Development

Subfield with 3 columns simultaneously

davidargz — Sat, 16 Nov 2024 04:50:54 GMT

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.

Arthur_Fong — Wed, 28 Aug 2019 00:53:39 GMT

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 — Fri, 30 Aug 2019 14:58:34 GMT

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 — Fri, 30 Aug 2019 16:37:04 GMT

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.