Headings that span multiple columns in a pivot table

[Anonymous]

Hi all,

I've got a pivot table that has three month actuals and budget and also total and variance columns. These columns are all defined individually in the expressions as this allows me to add the variances.

I currently have text boxes to span the actuals, budget and variance columns, but obviously any changes in the column widths requires manual changes to the boxes.

I am therefore looking to include these headings in the table itself.

Any ideas?

Thanks!

Each column is defined separately:

[vinieme12]

Oh, Just spotted You have an "=" sign which is not needed on this line

          = if(Actual = 'Budget',

remove = sign from here

[Anonymous]

The only way I can think of at the moment is to calculate it all in your script.  So you end up with a table in your data model like this.

Month	Type	Amount
1-Jan	Actual	500
1-Feb	Actual	400
1-Mar	Actual	300
1-Jan	Budget	1000
1-Feb	Budget	2000
1-Mar	Budget	3000
Total	Budget	6000
Total	Actual	1200
YTDVariance	Variance	-4800
MTDVariance	Variance	-2700

And build your pivot table like in the attached example.

[vinieme12]

connocmay

if your query is resolved , please close the thread

Qlik Community Tip: Marking Replies as Correct or Helpful