Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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:
2) If your goal is move from :
to:
go under presentation and uncheck this:
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:
Hi Justin,
Please add the data in Column.
Thank you
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:
2) If your goal is move from :
to:
go under presentation and uncheck this:
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: