topic Re: Total Mode: Expression Total - How to get accurate average in QlikView https://community.qlik.com/t5/QlikView/Total-Mode-Expression-Total-How-to-get-accurate-average/m-p/449328#M1162436 <HTML><HEAD></HEAD><BODY><P>So that might work if I'm calculating an average accross rows but what if I'm calculating averages within each column?</P></BODY></HTML> Wed, 24 Oct 2012 17:34:06 GMT 2012-10-24T17:34:06Z Total Mode: Expression Total - How to get accurate average https://community.qlik.com/t5/QlikView/Total-Mode-Expression-Total-How-to-get-accurate-average/m-p/449326#M1162434 <HTML><HEAD></HEAD><BODY><P>I have a Chart of calculated averages. I wanted to have a Total Row at the bottom and I'm not sure what 'Expression Total' is calculating but it isn't what I need. Since each calculated value uses a different denominator I need to sum the numerators and divide that by the sum of denominators. Merely Averaging the averages will not work. Am I only able to accomplish this by creating my own Total Row with some complicated expressions? If so how do you reference values from other parts of the Chart. </P></BODY></HTML> Wed, 24 Oct 2012 15:44:32 GMT https://community.qlik.com/t5/QlikView/Total-Mode-Expression-Total-How-to-get-accurate-average/m-p/449326#M1162434 2012-10-24T15:44:32Z Re: Total Mode: Expression Total - How to get accurate average https://community.qlik.com/t5/QlikView/Total-Mode-Expression-Total-How-to-get-accurate-average/m-p/449327#M1162435 <HTML><HEAD></HEAD><BODY><P>I guess you may find useful the DIMENSIONALITY() function.</P><P></P><P>Add it as a expression to see the relationship between cells. The <EM>total </EM>cells have a zero dimensionality value, so you can then ask IF(DIMENSIONALITY()=0, ...) and set your own total expression.</P><P></P><P>Hope this helps.</P></BODY></HTML> Wed, 24 Oct 2012 16:36:57 GMT https://community.qlik.com/t5/QlikView/Total-Mode-Expression-Total-How-to-get-accurate-average/m-p/449327#M1162435 diegofcaivano 2012-10-24T16:36:57Z Re: Total Mode: Expression Total - How to get accurate average https://community.qlik.com/t5/QlikView/Total-Mode-Expression-Total-How-to-get-accurate-average/m-p/449328#M1162436 <HTML><HEAD></HEAD><BODY><P>So that might work if I'm calculating an average accross rows but what if I'm calculating averages within each column?</P></BODY></HTML> Wed, 24 Oct 2012 17:34:06 GMT https://community.qlik.com/t5/QlikView/Total-Mode-Expression-Total-How-to-get-accurate-average/m-p/449328#M1162436 2012-10-24T17:34:06Z Re: Total Mode: Expression Total - How to get accurate average https://community.qlik.com/t5/QlikView/Total-Mode-Expression-Total-How-to-get-accurate-average/m-p/449329#M1162439 <HTML><HEAD></HEAD><BODY><P>In that case maybe you'll need to AGGR() the average expression.</P><P></P><P>Please attach a mock application with this issue so we can help you further.</P></BODY></HTML> Wed, 24 Oct 2012 17:51:12 GMT https://community.qlik.com/t5/QlikView/Total-Mode-Expression-Total-How-to-get-accurate-average/m-p/449329#M1162439 diegofcaivano 2012-10-24T17:51:12Z Re: Total Mode: Expression Total - How to get accurate average https://community.qlik.com/t5/QlikView/Total-Mode-Expression-Total-How-to-get-accurate-average/m-p/449330#M1162441 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>If it possible with your data model: =Sum(Numerator)/Sum(Denominator)</P><P>This usually is a correct way to aggregate on both dimension and total levels.</P></BODY></HTML> Wed, 24 Oct 2012 19:12:41 GMT https://community.qlik.com/t5/QlikView/Total-Mode-Expression-Total-How-to-get-accurate-average/m-p/449330#M1162441 whiteline 2012-10-24T19:12:41Z