topic Grouping Values from a field in QlikView

Grouping Values from a field

Tue, 21 Aug 2012 17:57:04 GMT

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

Case Types:

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.

Anonymous — Wed, 22 Aug 2012 00:04:39 GMT

Looks like you need this:

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

Regards,

Michael

rwunderlich — Wed, 22 Aug 2012 04:26:32 GMT

Look at MAPPING in the Help and Ref Guide.

-Rob

bgerchikov — Wed, 22 Aug 2012 04:37:33 GMT

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!