Force items to show in Pivot table regardless of selections

[dukane24]

Hello,

I have a pivot table listing individuals, their inventory totals, and their capacity based on the amount of work they have.  The user would like to show all individuals, all the time, regardless of what selections are made.  Depending on the date they may show as having zero inventory, but that's ok.  This seems to go against how QlikView works and I'm not sure it's possible, but if you have any ideas, I would certainly be grateful.

Here is a sample of the pivot table:

Name		Total
John	Inventory	7
	Capacity	5:32:00
Sam	Inventory	14
	Capacity	2:19:30
Sally	Inventory	0
	Capacity	8:00:00

Thank you

[krishnacbe]

Hi,

If you need to avoid any selection you can user Set Expression like Sum({1}Measure)

or to exclude particular selection try below expression.

Sum({<Name=>}Measure) this will exclude the selections you made in Name field.