Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Grouping Values from a field

I have several case prefixes that I need to place in groups.

Case Types:

G

SA

BR

OR

MF

I need groupings:

Case Type | Group

G = Global

SA = TC/PC

BR = TC/PC

OR = TC/PC

MF = TC/PC

So that I have a QV field to choose either GLOBAL or TC/PC

Any help would be apprieciated.

3 Replies
mov
Esteemed Contributor III

Re: Grouping Values from a field

Looks like you need this:

if([Case Type]='G', 'Global', 'TC/PC') as Group

Regards,

Michael

Re: Grouping Values from a field

Look at MAPPING in the Help and Ref Guide.

-Rob

bgerchikov
Contributor III

Re: Grouping Values from a field

Hmmm... My previous post got lost for some reason.

Here is another suggestion:

Sinse you have only 2 possible values for Group field, you can use IF expression:

If([Case Type] = 'G', 'Global','TC/PC') as Group;

good luck!

Community Browser