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: 
JustinDallas
Specialist III
Specialist III

Add second column to Pivot Table

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

1 Solution

Accepted Solutions
OmarBenSalem

I don't really get what you're willing to do;

1) If you want to change the place of a field , you can just drag and drop it:

Capture.PNG

2) If your goal is move from :

Capture.PNG

to:

Capture.PNG

go under presentation and uncheck this:

Capture.PNG

3) Now if you want to add sum(Sales) (for example, ur measure), besides the column:

transform your column from :

ord_hdrnumber

to

ord_hdrnumber &' / Sales :'& aggr(sum(Sales),ord_hdrnumber )


Per analogy:

Capture.PNG

View solution in original post

2 Replies
Not applicable

Hi Justin,

      Please add the data in Column.

Capture.PNG

Thank you

OmarBenSalem

I don't really get what you're willing to do;

1) If you want to change the place of a field , you can just drag and drop it:

Capture.PNG

2) If your goal is move from :

Capture.PNG

to:

Capture.PNG

go under presentation and uncheck this:

Capture.PNG

3) Now if you want to add sum(Sales) (for example, ur measure), besides the column:

transform your column from :

ord_hdrnumber

to

ord_hdrnumber &' / Sales :'& aggr(sum(Sales),ord_hdrnumber )


Per analogy:

Capture.PNG