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.


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