topic Mean in Total Mode in QlikView https://community.qlik.com/t5/QlikView/Mean-in-Total-Mode/m-p/190306#M52871 <HTML><HEAD></HEAD><BODY><P>Hello Dinesh,</P><P>Have you tried "Average"? Is that what you expect?</P></BODY></HTML> Wed, 30 Mar 2011 14:02:25 GMT Miguel_Angel_Baeyens 2011-03-30T14:02:25Z Mean in Total Mode https://community.qlik.com/t5/QlikView/Mean-in-Total-Mode/m-p/190305#M52870 <HTML><HEAD></HEAD><BODY><P>Mean is not available in drop down of "Total Mode" in Straight table \ Expressions. Is there any work around?</P><P></P><P>Thanks,</P><P>Dinesh.</P></BODY></HTML> Wed, 30 Mar 2011 13:47:00 GMT https://community.qlik.com/t5/QlikView/Mean-in-Total-Mode/m-p/190305#M52870 Anonymous 2011-03-30T13:47:00Z Mean in Total Mode https://community.qlik.com/t5/QlikView/Mean-in-Total-Mode/m-p/190306#M52871 <HTML><HEAD></HEAD><BODY><P>Hello Dinesh,</P><P>Have you tried "Average"? Is that what you expect?</P></BODY></HTML> Wed, 30 Mar 2011 14:02:25 GMT https://community.qlik.com/t5/QlikView/Mean-in-Total-Mode/m-p/190306#M52871 Miguel_Angel_Baeyens 2011-03-30T14:02:25Z Mean in Total Mode https://community.qlik.com/t5/QlikView/Mean-in-Total-Mode/m-p/190307#M52872 <HTML><HEAD></HEAD><BODY><P>I misspoke. I was looking for median as average misleads when there are outliars. Thoughts?</P></BODY></HTML> Wed, 30 Mar 2011 16:31:36 GMT https://community.qlik.com/t5/QlikView/Mean-in-Total-Mode/m-p/190307#M52872 Anonymous 2011-03-30T16:31:36Z Mean in Total Mode https://community.qlik.com/t5/QlikView/Mean-in-Total-Mode/m-p/190308#M52873 <HTML><HEAD></HEAD><BODY><P>How about Fractile(total FIELD, 0.5)</P></BODY></HTML> Wed, 30 Mar 2011 16:37:18 GMT https://community.qlik.com/t5/QlikView/Mean-in-Total-Mode/m-p/190308#M52873 danielrozental 2011-03-30T16:37:18Z Mean in Total Mode https://community.qlik.com/t5/QlikView/Mean-in-Total-Mode/m-p/190309#M52874 <HTML><HEAD></HEAD><BODY><P>That is a good thought. Thanks. I guess I can make it simpler by using median(total fielda). The disadvantage is that I want to see the actual value of fielda, but the median in the total line.</P><P>Thoughts?</P><P>Dinesh.</P></BODY></HTML> Wed, 30 Mar 2011 17:54:31 GMT https://community.qlik.com/t5/QlikView/Mean-in-Total-Mode/m-p/190309#M52874 Anonymous 2011-03-30T17:54:31Z