topic Re: removing unneccesary data from Listbox in QlikView

removing unneccesary data from Listbox

Tue, 02 Sep 2014 11:28:52 GMT

hi all

I have fields values like

I want output like this.

How we can get it,any suggestions.

Thanks

tresB — Tue, 02 Sep 2014 11:30:35 GMT

Load

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

v_iyyappan — Tue, 02 Sep 2014 11:31:52 GMT

Hi,

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

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

Regards,

MK_QSL — Tue, 02 Sep 2014 11:33:19 GMT

Use below in your script instead of Country

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

PrashantSangle — Tue, 02 Sep 2014 11:33:25 GMT

Hi,

Try like this,

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

Regards

ashfaq_haseeb — Tue, 02 Sep 2014 11:36:23 GMT

try below

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

Regards

ASHFAQ

MK_QSL — Sun, 07 Sep 2014 19:16:47 GMT

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

Mon, 08 Sep 2014 09:05:40 GMT

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