topic Re: Re: Avg Hours in QlikView https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589009#M218432 <HTML><HEAD></HEAD><BODY><P>Please check enclosed file...</P></BODY></HTML> Tue, 18 Mar 2014 12:44:02 GMT MK_QSL 2014-03-18T12:44:02Z Avg Hours https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589003#M218426 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Some one help me</P><P>How to calculate Avg hours per person per month</P><P>Give me some idea</P><P>im using personal edition</P><P></P><P>Thanks In Advance</P><P>Niru&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Tue, 18 Mar 2014 12:06:46 GMT https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589003#M218426 NavinReddy 2014-03-18T12:06:46Z Re: Avg Hours https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589004#M218427 <HTML><HEAD></HEAD><BODY><P>Can you share some sample data.</P></BODY></HTML> Tue, 18 Mar 2014 12:12:49 GMT https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589004#M218427 jsingh71 2014-03-18T12:12:49Z Re: Avg Hours https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589005#M218428 <HTML><HEAD></HEAD><BODY><P>Need at least some sample data !</P></BODY></HTML> Tue, 18 Mar 2014 12:17:51 GMT https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589005#M218428 MK_QSL 2014-03-18T12:17:51Z Re: Avg Hours https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589006#M218429 <HTML><HEAD></HEAD><BODY><P>Please find the sample these may help you</P><P>and instead of per month i used day, you may change requirement</P><P></P><P>In expression</P><P>avg(Aggr(DISTINCT</P><P>Count( Hour),Person,Month))</P></BODY></HTML> Tue, 18 Mar 2014 12:31:24 GMT https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589006#M218429 sunilkumarqv 2014-03-18T12:31:24Z Re: Avg Hours https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589007#M218430 <HTML><HEAD></HEAD><BODY><P>hi manish,</P><P>Please find sample data</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD height="17" width="64">person</TD><TD width="64">Payhours</TD><TD width="64">Month</TD></TR><TR><TD height="17">A</TD><TD align="right" class="xl65">10.38</TD><TD align="right">1</TD></TR><TR><TD height="17">B</TD><TD align="right" class="xl65" style="border-top: medium none;">5.75</TD><TD align="right">2</TD></TR><TR><TD height="17">A</TD><TD align="right" class="xl65" style="border-top: medium none;">40</TD><TD align="right">1</TD></TR><TR><TD height="17">C</TD><TD align="right" class="xl65" style="border-top: medium none;">35</TD><TD align="right">2</TD></TR><TR><TD height="17">B</TD><TD align="right" class="xl65" style="border-top: medium none;">1.75</TD><TD align="right">1</TD></TR><TR><TD height="17">A</TD><TD align="right" class="xl65" style="border-top: medium none;">3.83</TD><TD align="right">2</TD></TR></TBODY></TABLE><P></P><P>Regards,</P><P>Niru</P></BODY></HTML> Tue, 18 Mar 2014 12:37:59 GMT https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589007#M218430 NavinReddy 2014-03-18T12:37:59Z Re: Avg Hours https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589008#M218431 <HTML><HEAD></HEAD><BODY><P>Create a chart with the fields <EM>Month</EM> and <EM>person</EM> as dimensions and as expression <EM>avg(Payhours)</EM>. If your field names are not <EM>Month,person</EM> and <EM>Payhours</EM>, then replace those names with the exact case-sensitive field names of your qlikview document.</P></BODY></HTML> Tue, 18 Mar 2014 12:38:33 GMT https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589008#M218431 Gysbert_Wassenaar 2014-03-18T12:38:33Z Re: Re: Avg Hours https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589009#M218432 <HTML><HEAD></HEAD><BODY><P>Please check enclosed file...</P></BODY></HTML> Tue, 18 Mar 2014 12:44:02 GMT https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589009#M218432 MK_QSL 2014-03-18T12:44:02Z Re: Avg Hours https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589010#M218433 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>Thanks for your replay</P><P>But i need to create <SPAN style="font-family: Calibri; color: black; font-size: 11pt;">Gauge Chart i need to impliment that expression</SPAN></P><P><SPAN style="font-family: Calibri; color: black; font-size: 11pt;">but gauge no dimension right Please help me</SPAN></P><P> </P><P><SPAN style="font-family: Calibri; color: black; font-size: 11pt;">Regards,</SPAN></P><P><SPAN style="font-family: Calibri; color: black; font-size: 11pt;">Niru</SPAN></P></BODY></HTML> Tue, 18 Mar 2014 12:56:34 GMT https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589010#M218433 NavinReddy 2014-03-18T12:56:34Z Re: Avg Hours https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589011#M218434 <HTML><HEAD></HEAD><BODY><P>Perhaps this: =avg(aggr(sum(Payhours),person,Month))</P></BODY></HTML> Tue, 18 Mar 2014 13:10:17 GMT https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589011#M218434 Gysbert_Wassenaar 2014-03-18T13:10:17Z Re: Avg Hours https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589012#M218435 <HTML><HEAD></HEAD><BODY><P>Hi manish,</P><P></P><P>i am using personal edition</P><P>will you please copy and paste expression here ,im trying to develop in gauge chat</P><P></P><P>Thanks In Advance</P><P>Niru</P></BODY></HTML> Tue, 18 Mar 2014 13:11:35 GMT https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589012#M218435 NavinReddy 2014-03-18T13:11:35Z Re: Avg Hours https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589013#M218436 <HTML><HEAD></HEAD><BODY><P>Thank you Gysbert</P><P><BR /> </P></BODY></HTML> Tue, 18 Mar 2014 13:17:17 GMT https://community.qlik.com/t5/QlikView/Avg-Hours/m-p/589013#M218436 NavinReddy 2014-03-18T13:17:17Z