Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

drillnaut
Valued Contributor

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

Tags (2)
1 Solution

Accepted Solutions
omarbensalem
Esteemed Contributor

Re: Add second column to Pivot Table

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

2 Replies
Not applicable

Re: Add second column to Pivot Table

Hi Justin,

      Please add the data in Column.

Capture.PNG

Thank you

omarbensalem
Esteemed Contributor

Re: Add second column to Pivot Table

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