topic Re: Create Field by grouping records in QlikView

Create Field by grouping records

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

Hi Every One,

I have one Field named Maintenance contains 8 records attached below.

From this field by grouping some records I need to create one more field called Maintenance Group Field contains 4 Records like below.

Please suggest is their any way to create like Maintenance Group Field from Maintenance field.

Thanks,

Re: Create Field by grouping records

its_anandrjs — Sat, 07 Oct 2017 13:59:24 GMT

Create another field in the table load

LOAD *,

if(Match(Names,'FS'),'FS',

if(Match(Names,'COM'),'COM',

if(Match(Names,'MI','MI-L'),'MI(MI,MI-L)',

if(Match(Names,'ISC','DENTRAL','KG','KB'),'OTHER')))) as Bucket;

LOAD * INLINE [

Names

COM

MI-L

ISC

DENTRAL

KB ];

Re: Create Field by grouping records

its_anandrjs — Sat, 07 Oct 2017 14:04:31 GMT

On load script try this

LOAD *,

if(Match(Maintenance,'FS'),'FS',

if(Match(Maintenance,'COM'),'COM',

if(Match(Maintenance,'MI','MI-L'),'MI(MI,MI-L)',

if(Match(Maintenance,'ISC','DENTRAL','KG','KB'),'OTHER')))) as MaintenanceGroup;

LOAD * INLINE [

Maintenance

COM

MI-L

ISC

DENTRAL

];

and you can directly try the calculated dimension in any chart

=if(Match(Maintenance,'FS'),'FS',

if(Match(Maintenance,'COM'),'COM',

if(Match(Maintenance,'MI','MI-L'),'MI(MI,MI-L)',

if(Match(Maintenance,'ISC','DENTRAL','KG','KB'),'OTHER'))))

Re: Create Field by grouping records

maxgro — Sat, 07 Oct 2017 14:11:21 GMT

pick wildmatch

load

pick(WildMatch([Maintenance Field],

'FS', 'COM', 'MI', 'MI-L', '*'),

'FS', 'COM', 'MI', 'MI', 'Other') as [Maintenance Group Field]

;

load * Inline [

Maintenance Field

COM

MI-L

ISC

CENTRAL

];

Re: Create Field by grouping records

bhavvibudagam — Sat, 07 Oct 2017 14:17:48 GMT

Thanks Anand. Nice Explanation.Its Working