Create auto range for alphabets

[Anonymous]

Dear Experts,

Could you please help me with the below syntax.

Is there a way we create create the automatic ranges for the alphabets in Qlikview like below.

Kindly refer the attachment.

I want to map the "Code" to another table based on the ranges.

Like A0A,A0B,A0C,A1B,B1A etc....

For all the above codes it should match 1001 etc...

Kindly help me.

Thanks & Regards

Jeba