topic How to select first word in a statement in QlikView

How to select first word in a statement

Dayna — Tue, 22 Sep 2009 15:24:58 GMT

Hello,

Only a small one, but we have multiple customers that belong to the same account, but the names differ, i.e.

Bubble Ltd
Bubble International
Bubble PLC
Health R US
Health Ltd
Health and Simple
Etc...

I want to provide the user with a list of just "Health" and "Bubble", only selecting the first word in each of these statements, as some customers could have 20+

Could you please advise as to the best method to do this?

Kind Regards,
Dayna

How to select first word in a statement

Tue, 22 Sep 2009 15:43:53 GMT

Hi,

You can create groups while loading data from qvd/database.

use the following code:-

if(Customer like 'Bubble*','Bubble', if(Customer like 'Health*','Health','Others')) as CustomerGroup

Now you will have groups :-

Bubble:- All the customers starting with Bubble.

Health:- All the remaining customers.

Now you can use CustomerGroup for selection.

Or the second idea is to provide a list box and ask the user to type the first word then all the possible values will be highlighted then press enter key. all the highlighted values will get selected.

If you have only 2-3 groups better create them using first idea, but if you have multiple groups then try the second one.

Hope this will help you.

Thanks & Best Regards,

Kuldeep Tak

How to select first word in a statement

Dayna — Tue, 22 Sep 2009 15:51:02 GMT

Hello,

Thank you for your quick response! Unfortunately, we have over 100 customers in the system, which changes all the time so I cant specifiy each group. Preferably, I need something that would automatically group them together depending on the first word (as this will always be the how to group the customer).

Kind Regards,

Dayna

How to select first word in a statement

Tue, 22 Sep 2009 16:03:20 GMT

Then you can use the second idea.

Thanks & Best Regards,

Kuldeep Tak

How to select first word in a statement

Tue, 22 Sep 2009 16:06:05 GMT

subfield(Customer,' ',1)

How to select first word in a statement

Dayna — Tue, 22 Sep 2009 16:06:24 GMT

Hello,

That is what they are currently doing, as the list box displays all the results. Unfortunately they would like to see the results as them grouped as the first word.

Kind Regards,

Dayna

How to select first word in a statement

Dayna — Tue, 22 Sep 2009 16:10:01 GMT

Perfect!

Thanks Richy!