how to write expression

[qlik_advance]

I have field 

(Region)

AP_India_1234

Result:     India-1234

I want result like that then what should I do for that 

Thanks

[amrinder · Accepted solution]

Hey,

Try this:

SubField(Region,'_',2)&'-'&SubField(Region,'_',3)

Regards,

Amrinder

[shiveshsingh]

May be this?

T:

Load SubField(Region,'_',2)&'-'&SubField(Region,'_',3)   as Result

Table_Name.qvd;

[qlik_advance]

thanks

[qlik_advance]

thanks..