topic Re: Show Partial Total wrong in QlikView

Show Partial Total wrong

MasterIvela — Wed, 08 Jun 2022 12:16:20 GMT

I have a problem with partial total in table

the total shown in the graph does not correspond to the actual total of the column if exported to excel.

the difference is big approximately 1MLN.

the formnula in expression is:

if(sum(if(ANNO_BUDGET_COMMESSA=Anno_Exp,FORECAST_COMMESSA))>(sum(if(ANNO_TBL=Anno_Exp,W_FT_VALORE_NETTO))+sum(if(P_ANNO_RICHIESTA_CONSEGNA=Anno_Exp , (P_OR_VALORE_RESIDUO)))),
sum(if(ANNO_BUDGET_COMMESSA=Anno_Exp,FORECAST_COMMESSA)),
sum(if(ANNO_TBL=Anno_Exp,W_FT_VALORE_NETTO))+sum(if(P_ANNO_RICHIESTA_CONSEGNA=Anno_Exp , (P_OR_VALORE_RESIDUO)))
)

what can i check?

Re: Show Partial Total wrong

MasterIvela — Wed, 08 Jun 2022 13:04:37 GMT

I understood the problem: the total of the graph does not consider the conditions in the expression

how can i create a total row that sums the column values?

thx

Re: Show Partial Total wrong

marcus_sommer — Wed, 08 Jun 2022 13:41:26 GMT

By using a straight-table you could change the calculation-mode within the tab expression on the right bottom to the sum of y-values. By using a pivot this feature isn't available and you will need to wrap your expression within an aggr() so that your expression looks like:

sum(aggr(YourExpression, Dim1, Dim2))

whereby Dim1 and Dim2 are placeholder for the needed dimensionality - which is usually the included chart-dimensions.

- Marcus