Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joshrussin
Creator III
Creator III

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
sunny_talwar

May be enable the total?

Capture.PNG

felipedl
Partner - Specialist III
Partner - Specialist III

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
Creator III
Creator III
Author

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

joshrussin
Creator III
Creator III
Author

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

sunny_talwar

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

joshrussin
Creator III
Creator III
Author

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%