Solved: removing unneccesary data from Listbox - Qlik Community

Report Inappropriate Content · ‎2014-09-02

hi all

I have fields values like

Country
[COUNTRY].[US]
COUNTRY].[UK]
COUNTRY].[IN]

I want output like this.

COUNTRY
US
UK
IN

How we can get it,any suggestions.

Thanks

ashfaq_haseeb · ‎2014-09-02

try below

TextBetween(COUNTRY, '[' , ']',2) as COUNTRY

Regards

ASHFAQ

View solution in original post

tresesco · ‎2014-09-02

Load

TextBetween(SubField(Country, '.',2), '[' , ']') as COUNTRY

v_iyyappan · ‎2014-09-02

Hi,

you can use the expression in General Proprieties in Field option.

Replace(Country, '[Country].',' ')

Regards,

MK_QSL · ‎2014-09-02

Use below in your script instead of Country

TextBetween(Country,'[',']',2) as Country

PrashantSangle · ‎2014-09-02

Hi,

Try like this,

TextBetween(Subfield(COUNTRY,'.',2), '[' , ']') as new_COUNTRY

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

ashfaq_haseeb · ‎2014-09-02

try below

TextBetween(COUNTRY, '[' , ']',2) as COUNTRY

Regards

ASHFAQ

MK_QSL · ‎2014-09-07

Just want to know whether my answer works for you or not...

Report Inappropriate Content · ‎2014-09-08

Yes Manish it was also worked..unfortunatly I did not notice your answer.