Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MasterIvela
Contributor
Contributor

Show Partial Total wrong

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?

MasterIvela_0-1654690517591.png

 

 

Labels (1)
2 Replies
MasterIvela
Contributor
Contributor
Author

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

MasterIvela_0-1654693408511.png

 

marcus_sommer

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