topic Formatting Table Headers in QlikView

Formatting Table Headers

Wed, 24 Jul 2013 14:12:34 GMT

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
X1	x2	y1	y2	Z1	Z2

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.

Re: Formatting Table Headers

Gysbert_Wassenaar — Wed, 24 Jul 2013 14:43:36 GMT

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.

Re: Formatting Table Headers

Wed, 24 Jul 2013 14:55:47 GMT

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.