Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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.
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.