I have a new problem in my dashboard, when I enable the "Show Partial Sums" in the Presentation Tab in my Chart Properties, I get a wrong value. In the snapshot bellow you can see it clearly that there is something wrong with the value:
My dimensions are:
My expressions are:
The [Imputacao%] values table:
What is the changes that I need to make to get the correct output result (1 316,41 €) for the totals of [Imputação] and (3 949,22 €)?
If anyone needs further more explanation, please ask it in the comment section bellow.
Solved! Go to Solution.
This was the solution that I could by myself get:
With the expressions be like:
Hope someone find a similar problem in the future and that this answers may give you a similar solution. Have fun and good job people
I wouldn't use dimensionality unless I wanted a different calculation on the totals - i.e. different from what I have on the rows. In your case, You want Sum(CustoReal) everywhere right?
No, if the subtotals are wrong, I'd say your data model is wrong. QlikView calculates correctly. It could e.g. be that the same dollar is asigned to several "Cod.Local" or to several "Zona". Then you would get exactly what you have here: A total that indeed is summed correctly in the fact table, but does not correspond to the sum of the lines in the pivot table.
My guess is that the "Zona" isn't connected to the data at all: Note that CBRASS is 398.50 no matter which "Zona" you look at.
PS If you create a text box with =Sum(CustoReal) in it, what do you get? This number is the true number in your data model.