Subfield function

[U_Waqar]

Hi Experts,
Have one ID column (data type is string in Qlik) and want to extract 2nd and 3rd character from it as belows:

I have tried using Subfield but not working as required. Please help.

Many Thanks,

[MarcoWedel · Accepted solution]

LOAD Num(Mid(ID,2,2)) as ExpectedOutput

FROM ...