topic Re: How to filter HAKKO customer ? in QlikView

How to filter HAKKO customer ?

paulyeo11 — Thu, 18 Jan 2018 06:27:24 GMT

Hi Sir

I have product field.

inside the product field it have data

Hakko

Hakko/Beckhoff

Hakko/Beckhoff/Mitsubishi

May i know how to create

a new field name "Hakko_User" to list those who customer interested in "Hakko"

a new field name "Beckhoff_User" to list those who customer interested in "Beckhoff"

So that i can easily filter out Hakko user.

Paul

Re: How to filter HAKKO customer ?

paulyeo11 — Thu, 18 Jan 2018 06:31:37 GMT

Re: How to filter HAKKO customer ?

kenphamvn — Thu, 18 Jan 2018 06:35:48 GMT

Using Index or substringcount function

Ex:

if (SubStringCount ( [product field], 'Hakko' ) >0 'Hakko','No Hakko') as Hakko_User

if (SubStringCount ( [product field], 'Beckhoff' ) >0 'Beckhoff','No Beckhoff') as Beckhoff_User

Regard

An Pham

Re: How to filter HAKKO customer ?

paulyeo11 — Thu, 18 Jan 2018 06:41:34 GMT

Hi Pham

I get error msg :-

Error in expression:

')' expected

Thank you for your help.

Paul Yeo

Re: How to filter HAKKO customer ?

kenphamvn — Thu, 18 Jan 2018 06:55:07 GMT

Sorry i missed comma in expression

please try again

LOAD
    COL_1,
    if (SubStringCount ( COL_1, 'Hakko' ) >0, 'Hakko','No Hakko') as Hakko_User,
    if (SubStringCount ( COL_1, 'Beckhoff' ) >0, 'Beckhoff','No Beckhoff') as Beckhoff_User
Resident tablename;

Regards

An Pham

Re: How to filter HAKKO customer ?

prma7799 — Thu, 18 Jan 2018 06:55:35 GMT

missing comma

if (SubStringCount ( [product field], 'Hakko' ) >0 , 'Hakko','No Hakko') as Hakko_User

if (SubStringCount ( [product field], 'Beckhoff' ) >0 , 'Beckhoff','No Beckhoff') as Beckhoff_User

Re: How to filter HAKKO customer ?

paulyeo11 — Thu, 18 Jan 2018 07:01:01 GMT

Thank you PM.

Re: How to filter HAKKO customer ?

paulyeo11 — Thu, 18 Jan 2018 07:04:00 GMT

Hi Pham

Can you share with me how you paste those script on your reply ? After you paste the back ground have line number 1 to 5.

Paul

Re: How to filter HAKKO customer ?

kenphamvn — Thu, 18 Jan 2018 07:08:59 GMT

Using Advanced Editor and format code

Regards

An Pham

Re: How to filter HAKKO customer ?

paulyeo11 — Thu, 18 Jan 2018 07:16:20 GMT

sub

wow this is very useful

thank you for sharing with me

end