topic average in QlikView https://community.qlik.com/t5/QlikView/average/m-p/235591#M86844 <HTML><HEAD></HEAD><BODY><P>This is probably simple but I'm still new to QV so...</P><P>I set up a count(x) expression to give me the total/ month, but now I need to get the average/day but that requires either the number of work days in a month or selected days in the Application. Can someone point me in the correct direction.</P><P></P><P>BV</P></BODY></HTML> Tue, 27 Jul 2010 21:20:33 GMT bvann040684 2010-07-27T21:20:33Z average https://community.qlik.com/t5/QlikView/average/m-p/235591#M86844 <HTML><HEAD></HEAD><BODY><P>This is probably simple but I'm still new to QV so...</P><P>I set up a count(x) expression to give me the total/ month, but now I need to get the average/day but that requires either the number of work days in a month or selected days in the Application. Can someone point me in the correct direction.</P><P></P><P>BV</P></BODY></HTML> Tue, 27 Jul 2010 21:20:33 GMT https://community.qlik.com/t5/QlikView/average/m-p/235591#M86844 bvann040684 2010-07-27T21:20:33Z average https://community.qlik.com/t5/QlikView/average/m-p/235592#M86845 <HTML><HEAD></HEAD><BODY><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">Count(x)/count(distinct(date(date))) would do it.</P><P style="margin:0in 0in 0pt;">(I've masked the date to date explicitly in case you have a datetime. Masking to date should turn it into a date, with no hours/mins, etc.)</P></BODY></HTML> Tue, 27 Jul 2010 23:43:29 GMT https://community.qlik.com/t5/QlikView/average/m-p/235592#M86845 2010-07-27T23:43:29Z average https://community.qlik.com/t5/QlikView/average/m-p/235593#M86846 <HTML><HEAD></HEAD><BODY><P style="margin:0in 0in 0pt;">Thank you I really appreciate you help, it works perfectly.</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">I actually have one more issue with that same table if you don't mind. I have built this in a pivot table and instead of allowing me to sum the actual numbers in the column it sums the expression (I'm assuming) What can I do to get it to sum the column?</P></BODY></HTML> Thu, 29 Jul 2010 17:23:21 GMT https://community.qlik.com/t5/QlikView/average/m-p/235593#M86846 bvann040684 2010-07-29T17:23:21Z