topic Re: IF Statement and Subfield function in QlikView

IF Statement and Subfield function

Fri, 31 Oct 2014 00:10:20 GMT

Hi everyone, I have an issue and i m trying to solve it. Here we go:

I have a field called CUSTOMERS, which can be a person or a company.

If it is a person the name is in the format: First Name Last Name Middle Name (eg JOHN TAYLOR ANDREW)

If it is a company it just shows the name of the company (eg XEROX SA)

The way to distinguish them is by another field called STATUS. So if it is a person then Status is Person. If it is a company it could be either Ltd, SA etc.

What I want to do is to keep the name of the customer as is if it is a company, and create two fields LAST NAME and FIRST NAME(or 3 if i want to keep middle name as well).

Any ideas??? Thanks much

Re: IF Statement and Subfield function

danieloberbilli — Fri, 31 Oct 2014 00:36:32 GMT

Maybe something like this. Please find qvw attached:

Re: IF Statement and Subfield function

danieloberbilli — Fri, 31 Oct 2014 00:48:57 GMT

But it needs some finetuning in case there is more than 1 middle name. In this case you could use the mid() und subfieldfunctions to identify the start position of the middle words.

Re: IF Statement and Subfield function

Fri, 31 Oct 2014 11:13:03 GMT

Thanks for the answer. The table on top is exactly what i am looking for.

However, I don't want to use INLINE. I have extracted all the customers in an Excel file

and I m using this. There are about 3K customers.

Any suggestions?

Re: IF Statement and Subfield function

danieloberbilli — Fri, 31 Oct 2014 14:26:26 GMT

instead of the inline load you can just use your load from...

Load *,

...

;

Load

STATUS,

CUSTOMERS,

...

from xyz.xls

Re: IF Statement and Subfield function

Sat, 01 Nov 2014 12:17:45 GMT

Thanks man. Very helpful!!!

Re: IF Statement and Subfield function

Sat, 01 Nov 2014 13:03:45 GMT

I was looking for same solution. i got it from your answer. Just in Time!!!!!!!

thanks