2 Replies Latest reply: Apr 8, 2017 3:31 AM by omar bensalem RSS

    Add second column to Pivot Table

    Justin Dallas

      Hello Everyone,

       

      I am coming to QlikSense from Qlikview.  In Qlikview, I can create a Pivot Table, and then add a column so that I end up with something like this.

                                                                       Sum(DoughnutCount)

      +  State |  StateAbbrev |                              |      360,000

                                        | SomeCityOne         |      240,000

                                        | SomeCityTwo         |      120,000

       

      How can I get the StateAbbrev into a column beside the State column without having some aggregate function?  Here is an image of what I am attempting to do.  I would like to get the Miles sitting beside the ord_hdrnumber in its own column, but I'm not sure how.

       

      MileageCapture.PNG