Renaming Field Results

[Anonymous]

Hello, I have some data in Qlikview that I am attempting to group together to make the reporting easier to read. My report is a bar chart that looks at my company's total number of orders per qtr and I want to break down the data by EDI vs "Manual" data. I am using our companies Sales Channel for the breakdown. There is no 'Manual' Sales Channel, we have numerous Sales Channels that I want to lump into a 'Manual' Grouping. In OBI, I did this with the below SQL.

CASE WHEN ("Sales Orders"."Sales Channel Code") IN ('DOMESTIC DEALER' , 'GPO' , 'DIRECT' , 'DOMESTIC DEALER - ALPHA' , 'VERBAL_ORDER' , 'DOMESTIC DEALER - ASSOCIATED' , 'PHONE_ORDER' , '-1' , 'SUPPLY CHAIN - TRIAD' , 'ORDER FORM' , 'DOMESTIC DEALER - GRAND' , 'EMAIL_CENTER' , 'DOMESTIC DEALER - COMMONWEALTH' , 'SUPPLY CHAIN - HCA GULF' , 'SUPPLY CHAIN - THR')  THEN 'Manual'  WHEN ("Sales Orders"."Sales Channel Code") IN ('EDI') THEN 'EDI'  ELSE 'Unspecified' END

How could I do this in QlikView? I would like to avoid the script editor.

Thanks!

[sinanozdemir · Accepted solution]

This could be one way to do:

If(WildMatch([Sales Channel Code], 'DOMESTIC DEALER' , 'GPO' , 'DIRECT' , 'DOMESTIC DEALER - ALPHA' , 'VERBAL_ORDER' , 'DOMESTIC DEALER - ASSOCIATED' , 'PHONE_ORDER' , '-1' , 'SUPPLY CHAIN - TRIAD' , 'ORDER FORM' , 'DOMESTIC DEALER - GRAND' , 'EMAIL_CENTER' , 'DOMESTIC DEALER - COMMONWEALTH' , 'SUPPLY CHAIN - HCA GULF' , 'SUPPLY CHAIN - THR'), 'Manual', If(WildMatch([Sales Channel Code], 'EDI'), 'EDI', 'Unspecified'))

You can use this to create a new dimension in your chart.

Hope this helps.

[Anonymous]

Thanks you Sinan! Exactly what I needed

[sinanozdemir]

You are welcome.