Pivot Table Label Expresion

dhborchardt — Thu, 20 Jun 2013 14:18:41 GMT

I would like to show the Sum of vacation days for each department and keep it static like in the example below. I am guessing I need to do a expression in the label. Something like: =Department & " = " & Sum(xxxxxxxx). x = the sum of all the employees in the department featured. Maybe there is a more elegant way to do this?

Pivot Table
Department	Name	Vacation Days
Finance = 22	Bob	11
	Sue	4
	Phil	7
Sales = 16	Joe	5
	Kim	2
	Bill	9
Shipping = 14	Jane	8
	Doug	1
	Jill	5

Re: Pivot Table Label Expresion

Gysbert_Wassenaar — Thu, 20 Jun 2013 14:21:43 GMT

You'll need a calculated dimension: =[Department] & ' = ' & aggr(sum(xxxxx),Department). It's not very elegant, but it's the only way. You can't create dynamic labels for (sub)totals for individual dimension values.

topic Pivot Table Label Expresion in QlikView

Pivot Table Label Expresion

Re: Pivot Table Label Expresion