i got the problem that the total from qlik sense calculates wrong.
I got 3 Dimensions 1. area Manager 2. district Manager and 3. stores
So now i got two Values, which need to be the same result. The first one i called '1' sums up our plan for the stores on day level and the second called '2' is on month level.
If i show up the result for the stores the values are the same but in the dimension area manager or district manager the values are different. Including null values are all activated....
A total is only the sum of the rows if a simple sum(Field) is used. As far as there are multiple fields included, for example by applying conditions and/or calculating any kind of rates their evaluation on the total-level could be different to the more granular dimension-level.
To enforce the above mentioned row-level summing you may wrap the calculation with an aggr() which might then be looking like:
sum(aggr(YourExpression, Dim1, Dim2))
whereby Dim1 & Dim2 are just a placeholder for the needed dimensionality context which are most often the dimensions from the object.
