topic Total for Count in Pivot table in QlikView

Total for Count in Pivot table

Thu, 28 Oct 2010 22:02:06 GMT

Hi,

Can somebody tell me how to change the formula to sum all rows in this pivot table?

Thanks

johnw — Thu, 28 Oct 2010 22:04:14 GMT

I believe this:

sum(aggr(count({<Year={2010}>} distinct No.C),MonthYear))

Thu, 28 Oct 2010 22:07:59 GMT

Thanks a lot John.

Tue, 26 Jul 2011 09:23:34 GMT

Hi,

i am new in qlikview system.Please help me regarding my concern.

Can anybody tell me what should be the exact formula?

The delivery qty.and quantity reduced should be the same quantity.The formula of delivery quantity is correct.

This is my formula - Sum (DISTINCT ([QUANTITY REDUCED]))

Please see attached file.

The table should be like this.

Thanks a lot.