Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
JonnyPoole
Employee
Employee

If your field name is [FieldName]:

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

View solution in original post

6 Replies
senpradip007
Specialist III
Specialist III

Can you upload sample qvw?

anbu1984
Master III
Master III

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

Hi,

can you explain

What is your Subfield() expression?

What you are getting?

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 🙂
JonnyPoole
Employee
Employee

If your field name is [FieldName]:

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

sathishkumar_go
Partner - Specialist
Partner - Specialist

HI,

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

 

Regards

Sathish

Not applicable
Author

Thanks. Its working.