Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formatting Table Headers

All,

I would like to know if there is a way to create a table header in the below format.

           Total X           Total Y          TotalZ
     X1x2      y1y2      Z1Z2

I need a have two columns insider a single column. I believe it can be done using pivote tables but once I have the table, I need to sort the table based on field which is not going to be in the table.

I could make the sorting with the "Table Box" but I not sure it will be possible using "Pivot Table"

Any suggestions pls.

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can use text boxes and place those over the headers. Or for a pivot table you can first create an extra table with a field for the totals labels:

Field A, Field B

Total X, X1

Total X, X2

Total Y, Y1

Total Y, Y2

Total Z, Z1

Total Z, Z2

You can the add the new Field A as a dimension in the pivot table and put it above Field B.

That obviously won't work if X1, X2, Y2 ... etc are not values from a field (named Field B in this example), but expressions.


talk is cheap, supply exceeds demand
Not applicable
Author

Gysbert,

Thanks for your suggestions. I think adding text boxes would be a simple but effective solution for me in this case. But I will try both.