topic Group into one in QlikView

Group into one

soha1902 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have below field

Customer

ABC Corp

ABC Limited

XYZ

DEF

HJK ASSOCIATES

HJK Finance

My Requirement is if 2 Customer names having the similar left name then I need to combine them into one name.

For example in above fields we have ABC CORP and ABC LIMITED so here ABC is common for both so I need to combine as ABC, likewise HJK ASSOCIATES and HJK Finance as HJK.

I want to implement this in UI level not in script level plz suggest.

Re: Group into one

swuehl — Thu, 02 Jun 2016 11:45:39 GMT

I would strongly suggest that you do this in the script, e.g. using a MAPPING approach:

Data Cleansing

You can also use Wildmatch() function to create your groups in calculated dimensions, but why don't you want to do this once in the script?

Re: Group into one

MindaugasBacius — Thu, 02 Jun 2016 11:45:40 GMT

Then in calculated dimensions use this script:

=subfield(Customer, ' ', 1)