topic Sum of Rows in Pivot Table in QlikView

Sum of Rows in Pivot Table

Wed, 21 Oct 2009 20:41:06 GMT

I've tried the format from the manual but I cannot get the correct totals in the pivot table.

All numbers are 37 times what they should be.

I've tried "sum(SALESPOTENTIAL)" and "sum(aggr(sum(SALESPOTENTIAL), CHANNEL, TYPE))" The results are the same with both.

Channel	TYPE	Sales Potential
A	Distribution Program	$101405900.00
A	Multi-Family Use	$3700000.00
B	Distribution Program	$233100000.00
C	Distribution Program	$7992000.00
D	Commercial Use	$20491488.00
	Distribution Program	$74074000.00
	Multi-Family Use	$2131200.00
	Trading Opportunity	$4440000.00
E	Distribution Program	$38369000.00
	Multi-Family Use	$2664000.00
	Trading Opportunity	$13542000.00
F	Commercial Use	$740000.00
F	Distribution Program	$47892800.00
G	Residential Quote	$444000.00
H	Distribution Program	$74495800.00
H	Multi-Family Use	$4144444.00
I	Commercial Use	$31969628.00
I	Multi-Family Use	$187598140.00
Total		$849194400.00

Sum of Rows in Pivot Table

sathishkumar_go — Wed, 21 Oct 2009 20:49:30 GMT

can u attach ur application here?

Regards

Sathish

Sum of Rows in Pivot Table

Wed, 21 Oct 2009 22:37:58 GMT

Thank You, application attached

Sum of Rows in Pivot Table

johnw — Thu, 22 Oct 2009 04:46:05 GMT

I don't have a solution, but if you make a list box of the opportunity ID, and select "show frequency", you'll see that every opportunity ID is duplicated 37 times. Why you have 37 rows instead of one for every ID, I don't know, but that's why your amounts are all 37 times too high. Normally when I see too many rows, it's because I did a join incorrectly, but in this case, none of your tables are joined, so that doesn't seem like the problem.

Sum of Rows in Pivot Table

Thu, 22 Oct 2009 05:33:25 GMT

Thanks, I'll try and figure out why that is