topic Calculating Total in Pivot Table With Drill Down Group in QlikView

Calculating Total in Pivot Table With Drill Down Group

madhubabum — Mon, 31 Aug 2015 07:50:54 GMT

Hi all

I am Using Pivot Table with Drill Down Group as ::::Region > District > Client > Profit Center (4 Dimensions)

Note : Partial Sum (Enabled)

If i am Click on region level (Showing Totals as Errors) , same as District , Client , Profit Center

I am attaching the Screen shots as attached document

So,How can i resolve the Problem ?

Thanks

Madhu

gautik92 — Mon, 31 Aug 2015 07:55:22 GMT

attach the sample qvw file

madhubabum — Tue, 01 Sep 2015 05:47:08 GMT

Hi Gowtham

Have you got any idea ?

jonathandienst — Tue, 01 Sep 2015 06:04:32 GMT

Your Total Equipment expression needs to include the table dimensions in the Aggr expression. You can do this:

sum(Aggr(Count(EquipmentModelName),

EquipmentGroupName,EquipmentClassName,

EquipmentCategoryName,EquipmentModelName,

$(=GetCurrentField(<your group name here>))

))

Insert your correct group name into the above expression where indicated.