Discussion board where members can get started with QlikView.
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
Capital Jones Northy
I used Subfield but it is not showing correct. can anyone please suggest me how to set this.
Go to Solution.
If your field name is [FieldName]:
=left( [FieldName], Index( [FieldName], ',') -1 )
View solution in original post
Can you upload sample qvw?
Load Subfield(Txt,',',1) Inline [
Capital Jones Northy,Carlton House,Mary Street,Salford,I90 UI0 ]
can you explain
What is your Subfield() expression?
What you are getting?
Try this subfield(Name,',',1) as Name
Thanks. Its working.