Subtotals that equal zero do not show

dwh1104 — Thu, 03 Jun 2010 21:31:23 GMT

I have a pivot table that when the values for "Activities" sum up to 0, the subtotals do not appear. However, when adding dimensionality() as an expression, then the subtotals appear correctly. Please see the example below...

Activity	Activity Description	Source	GL Entry Name	GL Amount
A06E-019	RESUSCITAIRE WARMER	AD	997810 DRAEGER MEDICAL	($482.18)
A06E-019	RESUSCITAIRE WARMER	CP	WORK IN PROCESS	$482.18
A06P-500CONST	AIR HANDLER UPGRADES CONSTRUCT	AD	70000 OSCAR J BOLDT CONSTRUCTION	$1,446.53
A06P-500CONST	Total			$1,446.53
A08E-109	WAITING ROOM FURNITURE	AD	146000 EMMONS BUSINESS INTERIORS	$46,165.43
A08E-109	WAITING ROOM FURNITURE	CP	WORK IN PROCESS	($46,165.43)
A08E-707	ORTHOPEDIC DRILLS	AD	419500 SYNTHES LTD	$37,903.68
A08E-707	ORTHOPEDIC DRILLS	CP	WORK IN PROCESS	($37,903.68)
Total				$1,446.53
				$1,446.53
With Dimensionality() expression
Activity	Activity Description	Source	GL Entry Name	GL Amount	Dimensionality()
A06E-019	RESUSCITAIRE WARMER	AD	997810 DRAEGER MEDICAL	($482.18)	10
A06E-019	RESUSCITAIRE WARMER	CP	WORK IN PROCESS	$482.18	10
A06E-019	Total			$0.00	2
A06P-500CONST	AIR HANDLER UPGRADES CONSTRUCT	AD	70000 OSCAR J BOLDT CONSTRUCTION	$1,446.53	10
A06P-500CONST	Total			$1,446.53	2
A08E-109	WAITING ROOM FURNITURE	AD	146000 EMMONS BUSINESS INTERIORS	$46,165.43	10
A08E-109	WAITING ROOM FURNITURE	CP	WORK IN PROCESS	($46,165.43)	10
A08E-109	Total			$0.00	2
A08E-707	ORTHOPEDIC DRILLS	AD	419500 SYNTHES LTD	$37,903.68	10
A08E-707	ORTHOPEDIC DRILLS	CP	WORK IN PROCESS	($37,903.68)	10
A08E-707	Total			$0.00	2
Total				$1,446.53	1
				$1,446.53	0

I really do not want the dimensionality column to show in the table. I have tried to include the dimensionality function into the GL Amount expression with no luck. Any help is greatly appreciated.

GL Amount = sum([GL Line Amount])

Thanks,

Dan

Subtotals that equal zero do not show

dwh1104 — Wed, 09 Jun 2010 15:27:58 GMT

I actually figured out a work-around for this. I included the Dimensionality expression, then set the background and text to White(). May not be ideal, but it works for my application.

Thanks,

Dan

topic Subtotals that equal zero do not show in QlikView

Subtotals that equal zero do not show

Subtotals that equal zero do not show