topic Re: I need to know how to split data in qlikview? in Data Movement & Streaming

I need to know how to split data in qlikview?

Hiran_Bandara — Wed, 19 Mar 2025 23:02:17 GMT

Re: I need to know how to split data in qlikview?

Oleg_Troyansky — Tue, 22 Aug 2023 15:52:16 GMT

Hi,

Can you be more specific, please? Your question is too vague, it doesn't convey the problem.

Cheers,

Re: I need to know how to split data in qlikview?

Hiran_Bandara — Tue, 22 Aug 2023 16:20:32 GMT

KN0023D12378 = KN +0023D12378 (same like this)

Re: I need to know how to split data in qlikview?

BrunPierre — Tue, 22 Aug 2023 16:48:34 GMT

In this case, you can derive new fields using the Left() and Mid() like this;

Left(Trim(FieldName), 2) as FirstTwo
Mid(Trim(FieldName), 3) as AfterFirstTwo

Re: I need to know how to split data in qlikview?

Oleg_Troyansky — Tue, 22 Aug 2023 17:30:40 GMT

As suggested, Left(), Mid(), RIght(), Subfield() and several other "String Functions" (search for them in Help) can be used to split strings into substrings.