Total value showing wrong in pivot table

[Anonymous]

Hi,

I am calculating sum of sales value, the total showing in the pivot table is different from the total in excel. Sales values are both positive and negative.

For eg; the total i got from pivot table is 35971.85 but the same calculated in excel showing 36033.07.

[tamilarasu]

Hi Remya,

Could you attach a sample file?

[sibin_jacob]

it may be because of your Dimension, there may be some null values in the data.

Go to Dimension tab-> then uncheck supress when value is null

[Anonymous]

Hi,

The attached file is downloaded from qlik.

[tamilarasu]

Try like this as your expression,

Sum(Aggr(Sum(Sales), Region, RouteCode))

[Anonymous]

Actually this is in a self service report, so the dimension will change.

This is the expression am using for sales value

Sum({$<DateKey={">=$(=Date(vFromDate,'YYYYMMDD'))<=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=>} $(eSales))

-

Sum({$<DateKey={">=$(=Date(vFromDate,'YYYYMMDD'))<=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=>} $(eRent))

[tamilarasu]

Remya Sujith wrote:

Actually this is in a self service report, so the dimension will change.

Is that mean cyclic group or variables? Is it possible to attach your qvw file here?

Preparing examples for Upload - Reduction and Data Scrambling

[Anonymous]

Sorry I cannot attach.

It is like the dimension can be chosen by the user, they can select route and sales value or item and sales value or customer and sales value for a range of from date and to date.

[tamilarasu]

Remya Sujith wrote:

It is like the dimension can be chosen by the user, they can select route and sales value or item and sales value or customer and sales value for a range of from date and to date.

Sorry. I just want to know how the dimensions are defined. So that we can include the same in Aggr function.

[Anonymous]

Some of the sub totals are wrong, and the total is calculating by adding those subtotals. If I calculate with values it will give the correct values.