Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

wrong total sums in chart

hi,

i have a chart and one expressions looks like this: avg(Versand_Dat.VERSADAT) - min(Artikelstamm.WE) for eacht row in the chart the result is right but the total sum in the pivot table is incorrect. I kind of understand why but I don't know how to solve it? I posted a screenshort as an example. in the screenshot you can see that the total sum is incorrect it should be the average of all the other values

can someone help me?

regards,

MT

3 Replies
swuehl
MVP
MVP

A pivot table will always use expression total as total mode. You might want to look into the HELP, sum-of-rows in pivot tables using advanced aggregation.

Something like

=sum( aggr( avg(Versand_Dat.VERSADAT) - min(Artikelstamm.WE), DIM1, DIM2, DIM3))

Not applicable
Author

I read this already....the problem is that we have a dynamic chart. we are using conditions for the dimensions! and in total I think we have 20 dimensions

Not applicable
Author

how can I do this in a dynamic chart???