topic Re: Renaming Field Results in QlikView

Renaming Field Results

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

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!

Re: Renaming Field Results

sinanozdemir — Fri, 08 Apr 2016 19:42:15 GMT

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.

Re: Renaming Field Results

Anonymous — Fri, 08 Apr 2016 20:00:43 GMT

Thanks you Sinan! Exactly what I needed

Re: Renaming Field Results

sinanozdemir — Mon, 11 Apr 2016 15:06:02 GMT

You are welcome.