Excel formulation in QlikView

[#1]

Hello,

Does someone could inform me about the feasibility to retrieve some characters ("as STXT (N3; 6; 2)" in excel) but with QlikView? and create a new field?

Then, once this character has been recovered, is it possible to assign a specific name?

My example in Excel:

=SI(STXT(L2;6;1)="0";"DLP1";SI(STXT(L2;6;1)="1";"DLP1";SI(STXT(L2;6;1)="2";"DLP2";SI(STXT(L2;6;1)="3";"DLP2";"Unknown"))))

Thank you in advance for your assistance,

Best regards

Matthieu

[#2]

Hello all,

Thank you for your assistance. I found the solution with the mid function and thanks to you.

However, I have tried with pick match function and I do not understand well why it is not working ?

Regards,

[sasikanth]

Welcome