topic Re: Pivot Table sorting help in QlikView

Pivot Table sorting help

joshrussin — Wed, 04 Oct 2017 17:58:16 GMT

Hey everyone,

I have these 'types' of data.

I am trying to sort this data into a few different groups within a different pivot table, kind of like this.

Except I also want to add a 4th group called 'Total' that has all of the 'Types'

This is how I was trying. Any help or suggestions?

=if(WildMatch(SaTy_OTIF,'2MEM','2MMO','NB2','ZBPU','ZD2S','ZKR'),'Internal / Warehouse to Warehouse',

if(WildMatch(SaTy_OTIF,'ZEU1','ZIN1'),'OUS',

if(WildMatch(SaTy_OTIF,'OR','UB'),'Domestic',

if(WildMatch(SaTy_OTIF,'2MEM','2MMO','NB2','ZBPU','ZD2S','ZKR','ZEU1','ZIN1','OR','UB'),'test'))))

Re: Pivot Table sorting help

sunny_talwar — Wed, 04 Oct 2017 19:20:16 GMT

May be enable the total?

Re: Pivot Table sorting help

felipedl — Wed, 04 Oct 2017 19:22:31 GMT

Hi Joshua,

Create another field with the expressions your using, something like:

Table:

Load

SaTy_OTIF,

// Other fields here,

(

WildMatch(SaTy_OTIF,'2MEM','2MMO','NB2','ZBPU','ZD2S','ZKR'),'Internal / Warehouse to Warehouse',

(

WildMatch(SaTy_OTIF,'ZEU1','ZIN1'),'OUS',

(

WildMatch(SaTy_OTIF,'OR','UB'),'Domestic',

(

WildMatch(SaTy_OTIF,'2MEM','2MMO','NB2','ZBPU','ZD2S','ZKR','ZEU1','ZIN1','OR','UB'),

'test'

)

) as Group

From [Whatever];

in this way, you can put the dimension on the pivot table.

As to the total, you wouldn't need to create another field with a total qualifier. on the presentation tab of the pivot table, you can choose the "Totals" to create what you want.

Felipe.

Re: Pivot Table sorting help

joshrussin — Wed, 04 Oct 2017 19:35:08 GMT

This method still only shows the 'OUS', 'Domestic' and 'Internal / Warehouse to Warehouse' and not the 'Total'

Re: Pivot Table sorting help

joshrussin — Wed, 04 Oct 2017 19:35:37 GMT

Doing it this way seems to just show an average and not all of the data combined.

Re: Pivot Table sorting help

sunny_talwar — Wed, 04 Oct 2017 19:38:51 GMT

Are you look to show the Sum or the three numbers? 91.31% + 27.17% + 91.90% for On-Time?

Re: Pivot Table sorting help

joshrussin — Wed, 04 Oct 2017 20:00:47 GMT

If you look at the totals for the Comp Pivot, I am trying to use those values. So 'On-Time' for 'Total' would be 75610/81143 which is 93.2%

In-Full would be 94.6%

and OTIF would be 89.4%