[ASK] how to show only 1 word

[#1]

i have a field called "Payment"

and i wanna only show first word of every record

example, there's a record "Cash 54-FT"

so i just need the word "Cash" to show

how to do that?

i also have attached the file

many thx..

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7142.tes.rar:550:0]

[lironbaram]

hei ricardo

try this

[suniljain · Accepted solution]

pls replace string by your related field name.

=

subfield('Cash 54-FT',' ',1)