Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

joshrussin
Contributor II

Pivot Table sorting help

Hey everyone,

I have these 'types' of data.

2017-10-04_12-41-13.jpg

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

2017-10-04_12-53-56.jpg

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'))))

6 Replies
MVP
MVP

Re: Pivot Table sorting help

May be enable the total?

Capture.PNG

felipedl
Valued Contributor III

Re: Pivot Table sorting help

Hi Joshua,

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


Table:

Load

     SaTy_OTIF,

     // Other fields here,

     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'

                    )

               )

          )

     ) 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.

joshrussin
Contributor II

Re: Pivot Table sorting help

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

joshrussin
Contributor II

Re: Pivot Table sorting help

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

MVP
MVP

Re: Pivot Table sorting help

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

joshrussin
Contributor II

Re: Pivot Table sorting help

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%

Community Browser