Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Subfiled showing incorrect values

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.

1 Solution

Accepted Solutions
Employee
Employee

Re: Subfiled showing incorrect values

If your field name is [FieldName]:

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

View solution in original post

6 Replies
senpradip007
Valued Contributor III

Re: Subfiled showing incorrect values

Can you upload sample qvw?

anbu1984
Honored Contributor III

Re: Subfiled showing incorrect values

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

Txt

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

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

Re: Subfiled showing incorrect values

Hi,

can you explain

What is your Subfield() expression?

What you are getting?

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Employee
Employee

Re: Subfiled showing incorrect values

If your field name is [FieldName]:

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

View solution in original post

Highlighted
Partner
Partner

Re: Subfiled showing incorrect values

HI,

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

 

Regards

Sathish

Not applicable

Re: Subfiled showing incorrect values

Thanks. Its working.