Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Show part of the values in a field

Hi,

I have a field which has values like this:

Lease

---------

Expense - Lease

Income - Lease

What should I type in the script so the field will show only

Expense

Income

Thanks,

Alec

1 Solution

Accepted Solutions
swuehl
MVP
MVP

If ' - ' is the delimiter, try

LOAD

subfield(Lease, ' - ',1) as Lease,

....

FROM ... ;

View solution in original post

2 Replies
swuehl
MVP
MVP

If ' - ' is the delimiter, try

LOAD

subfield(Lease, ' - ',1) as Lease,

....

FROM ... ;

View solution in original post

alec1982
Specialist II
Specialist II
Author

This is working just perfect!

Thank you.