Extending pivot table sub-total labels over several columns

Mon, 12 May 2014 15:48:23 GMT

I have a pivot table where one sub-total is total hours worked during the period.

I want the sub-total label to state what the total is, and what dates are used.

I wrote the following expression:

='Totals for period from START '&min(workingday)&' TO '&max(workingday)

which works perfectly, but since the category it's applied to is quite narrow, the text wraps over 3 lines. I have five more

dimensions, and I'd like to this label to extend on one row over these columns, so that I have a better looking chart.

I also apply colour formatting to these (=if(RowNo()=0,yellow()) ), and I'd like that to extend as well.

Is there any way to accomplish this?

Thanks,

Kevin

Re: Extending pivot table sub-total labels over several columns

Gysbert_Wassenaar — Mon, 12 May 2014 16:29:56 GMT

You can't merge cells the way you can in Excel. So displaying an expression value across several columns is not possible.

You can use the same background color expression for the dimensions. Click on the + in front of the dimension, select Background Color, click on the Edit button and enter the expression.

topic Extending pivot table sub-total labels over several columns in QlikView

Extending pivot table sub-total labels over several columns

Re: Extending pivot table sub-total labels over several columns