Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Merging Group Names into one single Group

Hi,

I have extracted all the information from our call logging system and ran it into Qlikview, and in a field called suppgroup I have a list box with the following groups:

Builds

Financial Systems

Business Developer

Service Desk

Service Desk Desktop

Service Desk NHS

Technical Support

IT Support

Helpdesk

What I am looking to achieve is to put the above groups into a specific group.  Please see example below.

Builds, IT Support, Helpdesk = IT Support

Business Developer, Financial Systems = Business Systems

Service Desk, Service Desk Desktop, Service Desk NHS = Service Desk

Technical Support = Technical Support

As you can see above, I should only have 4 groups called, IT Support, Business Systems, Service Desk and Technical Support.

Would someone be able to help me with this query please?

Regards,

Jon Ditchfield

7 Replies
thomas_skariah
Contributor III

Re: Merging Group Names into one single Group

Hi,

Is this is the column names coming from a single table?

Builds

Financial Systems

Business Developer

Service Desk

Service Desk Desktop

Service Desk NHS

Technical Support

IT Support

Helpdesk

Regards,

Tom


Not applicable

Re: Merging Group Names into one single Group

Hi Tom,

Yes they are all coming from a table called opencall.

Regards,

Jon

thomas_skariah
Contributor III

Re: Merging Group Names into one single Group

Hi,

Hope this what you are looking for.

Builds &'-' &IT Support &'-'Helpdesk as IT-Support

Business Developer &'-'& Financial Systems as Business Systems

Service Desk &'-'& Service Desk Desktop &'-' & Service Desk NHS as Business Systems

Technical Support 

Regards,

Tom

thomas_skariah
Contributor III

Re: Merging Group Names into one single Group

Sorry i think this not what you looking for.

thomas_skariah
Contributor III

Re: Merging Group Names into one single Group

Hi

You can use concatenate statement

load Builds as  IT-Support,

Business Developer aS Business Systems ,

Service Desk AS Service Desk,

Technical Support 

from test.xls

concatenate

load IT Support as  IT-Support,

Financial Systems AS Business Systems

Service Desk Desktop AS Service Desk

FROM test XLS

CONCATENATE

LOAD
Service Desk NHS AS

Service Desk

from test.xls

Regards,

Tom


Not applicable

Re: Merging Group Names into one single Group

Thanks all,  Ill give them a try and let you know how I get on.

MVP
MVP

Re: Merging Group Names into one single Group

Here's one option:

[Groups]:
LOAD
group
,trim(subfield(suppgroups,',')) as suppgroup
INLINE [
group: suppgroups
IT Support: Builds, IT Support, Helpdesk
Business Systems: Business Developer, Financial Systems
Service Desk: Service Desk, Service Desk Desktop, Service Desk NHS
Technical Support: Technical Support
] (delimiter is ':');

Community Browser