topic Subfiled showing incorrect values in QlikView

Subfiled showing incorrect values

Tue, 23 Sep 2014 11:24:48 GMT

Hi,

I have cell values in chart column as below

Sertyuid, City Tower,Piccadilly Plaza,Bayymore, B1 UY8

Capital Jones Northy,Carlton House,Mary Street,Salford,I90 UI0

I need to split data as I have to show only Data as

Sertyuid

Capital Jones Northy

I used Subfield but it is not showing correct. can anyone please suggest me how to set this.

Thanks.

senpradip007 — Tue, 23 Sep 2014 11:27:37 GMT

Can you upload sample qvw?

anbu1984 — Tue, 23 Sep 2014 11:29:59 GMT

Load Subfield(Txt,',',1) Inline [

Txt

Sertyuid, City Tower,Piccadilly Plaza,Bayymore, B1 UY8

Capital Jones Northy,Carlton House,Mary Street,Salford,I90 UI0 ]

PrashantSangle — Tue, 23 Sep 2014 11:30:48 GMT

Hi,

can you explain

What is your Subfield() expression?

What you are getting?

Regards

JonnyPoole — Tue, 23 Sep 2014 11:32:06 GMT

If your field name is [FieldName]:

=left( [FieldName], Index( [FieldName], ',') -1 )

sathishkumar_go — Tue, 23 Sep 2014 11:32:34 GMT

HI,

Try this subfield(Name,',',1) as Name

Regards

Sathish

Tue, 23 Sep 2014 11:48:19 GMT

Thanks. Its working.