topic Re: Total Miss Matching In Pivot Table in QlikView

Total Miss Matching In Pivot Table

dineshm030 — Thu, 21 Sep 2017 16:17:26 GMT

Hi All,

Emergency!!!!

I created the report with pivot table by 4 dimensions. The total is mismatching in that report. Can you pls give the solution?

The original total is 1101547 but 1043921 is coming.

My Expression:

If(My Expression(Sales_Value))

If I am using AGGR condition, some values is not coming.

From the team, ONCOLOGY and RARE DISEASE is going to some other teams.

My Expression:

Sum(Aggr(If(My Expression(Sales_Value))),Group,Established Products,Local_BU))

Thanks in advance.

sunny_talwar — Thu, 21 Sep 2017 16:21:02 GMT

Is Sequence the same thing as Established Products and Team is same thing as Local_BU?

hic — Thu, 21 Sep 2017 17:21:17 GMT

A comments: The total in a chart is not (and should not be) the sum of rows. See more on

HIC