Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
qlik_advance
New Contributor II

how to write expression

I have field 

(Region)

AP_India_1234

 

Result:     India-1234

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

 

Thanks

1 Solution

Accepted Solutions
amrinder
Contributor

Re: how to write expression

Hey,

 

Try this:

 

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

 

Regards,

Amrinder

View solution in original post

4 Replies
amrinder
Contributor

Re: how to write expression

Hey,

 

Try this:

 

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

 

Regards,

Amrinder

View solution in original post

shiveshsingh
Honored Contributor

Re: how to write expression

May be this?

 

T:

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

Table_Name.qvd;

qlik_advance
New Contributor II

Re: how to write expression

thanks
qlik_advance
New Contributor II

Re: how to write expression

thanks..