I need to know how to split data in qlikview?

[Oleg_Troyansky]

Hi,

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

Cheers,

[Hiran_Bandara]

KN0023D12378 = KN +0023D12378 (same like this)

[BrunPierre]

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

[Oleg_Troyansky · Accepted solution]

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