topic use average as partial sum in QlikView https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113578#M898692 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>please check attached qvw. i want to get average hours and colur it in red when average is less than 8.</P><P></P><P>is it possible.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT anuradhaa 2020-11-25T16:16:04Z use average as partial sum https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113578#M898692 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>please check attached qvw. i want to get average hours and colur it in red when average is less than 8.</P><P></P><P>is it possible.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113578#M898692 anuradhaa 2020-11-25T16:16:04Z Re: use average as partial sum https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113579#M898693 <HTML><HEAD></HEAD><BODY><P>Please find attached.</P></BODY></HTML> Thu, 21 Jul 2016 05:20:10 GMT https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113579#M898693 2016-07-21T05:20:10Z Re: use average as partial sum https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113580#M898694 <HTML><HEAD></HEAD><BODY><P>No, this is not what i want.</P><P></P><P>i want to get the average of all the dates </P><P></P><P>sum(sum(hours)) - for all 10 days / count(number of days) 10</P></BODY></HTML> Thu, 21 Jul 2016 05:23:06 GMT https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113580#M898694 anuradhaa 2016-07-21T05:23:06Z Re: use average as partial sum https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113581#M898695 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>try with total</P><P></P><P>like Sum(Total hours)/ count(distinct number of days)</P><P></P><P>Regards</P></BODY></HTML> Thu, 21 Jul 2016 05:32:20 GMT https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113581#M898695 PrashantSangle 2016-07-21T05:32:20Z Re: use average as partial sum https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113582#M898696 <HTML><HEAD></HEAD><BODY><P>Try this pls.</P></BODY></HTML> Thu, 21 Jul 2016 05:35:09 GMT https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113582#M898696 2016-07-21T05:35:09Z Re: use average as partial sum https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113583#M898697 <HTML><HEAD></HEAD><BODY><P>Let me know.</P><P></P><P>if you don't get required result.</P></BODY></HTML> Thu, 21 Jul 2016 08:17:33 GMT https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113583#M898697 tyagishaila 2016-07-21T08:17:33Z Re: use average as partial sum https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113584#M898698 <HTML><HEAD></HEAD><BODY><P>no, you get daily average for all members, but i want the average hours of each member for whole period</P></BODY></HTML> Thu, 21 Jul 2016 16:56:32 GMT https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113584#M898698 anuradhaa 2016-07-21T16:56:32Z Re: use average as partial sum https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113585#M898699 <HTML><HEAD></HEAD><BODY><P>can you please share a sample</P></BODY></HTML> Thu, 21 Jul 2016 16:59:09 GMT https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113585#M898699 anuradhaa 2016-07-21T16:59:09Z Re: use average as partial sum https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113586#M898700 <HTML><HEAD></HEAD><BODY><P>Are you trying to get this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132104_Capture.PNG" style="height: 174px; width: 620px;" /></P></BODY></HTML> Thu, 21 Jul 2016 17:39:18 GMT https://community.qlik.com/t5/QlikView/use-average-as-partial-sum/m-p/1113586#M898700 sunny_talwar 2016-07-21T17:39:18Z