6 Replies Latest reply: Aug 31, 2017 2:44 PM by Sateesh s RSS

    Pivotal table columns as rows (Not data wise)

    Sateesh s

      I have pivotal table in qliksense. I need to convert as like below.

       

         

      Quarter2017 Q 2
      Quarterly SalesSalesCount Avg qtyUnits
      1 - 10K112-45
      10K - 50K551211
      50K - 100K444055
      100K - 250K3345511556
      250K - 500K52663477
      500K+2288-13

       

      The Converted table should be like as below and attached image:

       

                  Quarterly Sales      |Quarter | 2017 Q 2

      -----------------------------------------------------------------

      Sales     1 - 10K                                     11

                     10K - 50K                                  55

                      50K - 100K                              44

                     100K - 250K                              33

                     250K - 500K                               52

                     500K+                                          22

      Total                                                        217

      --------------------------------------------------------------

      Count       1 - 10K                                         2

                     10K - 50K                                    12

                     50K - 100K                                   4

                     100K - 250K                                455

                     250K - 500K                                  66

                     500K+                                            88

                   Total                                              627

      -----------------------------------------------------------------

      Avg qty          1 - 10K                                          -

                          10K - 50K                                    11

                          50K - 100K                                    0

                          100K - 250K                               11

                          250K - 500K                               34

                          500K+ -

                     Total                                                56

      -----------------------------------------------------------------

      Units           1 - 10K                                         45

                          10K - 50K

                           50K - 100K                                   55

                          100K - 250K                                  556

                          250K - 500K                                  77

                          500K+                                           13

                  Total                                                     746


      Can we transpose the pivotal table column wise not data wise? as per above table