topic count monthyear in QlikView https://community.qlik.com/t5/QlikView/count-monthyear/m-p/727932#M260865 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i have feild monthyear.</P><P>i want to count it for calculte averege for sum(kg).</P><P></P><P>if i write count(monthyear) - the resolt is not good.</P><P></P><P>thamks'</P><P>yarin.</P></BODY></HTML> Mon, 23 Jun 2014 11:33:22 GMT Anonymous 2014-06-23T11:33:22Z count monthyear https://community.qlik.com/t5/QlikView/count-monthyear/m-p/727932#M260865 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i have feild monthyear.</P><P>i want to count it for calculte averege for sum(kg).</P><P></P><P>if i write count(monthyear) - the resolt is not good.</P><P></P><P>thamks'</P><P>yarin.</P></BODY></HTML> Mon, 23 Jun 2014 11:33:22 GMT https://community.qlik.com/t5/QlikView/count-monthyear/m-p/727932#M260865 Anonymous 2014-06-23T11:33:22Z Re: count monthyear https://community.qlik.com/t5/QlikView/count-monthyear/m-p/727933#M260866 <HTML><HEAD></HEAD><BODY><P>may be count(distinct monthyear)</P><P>if possible, provide sample data</P></BODY></HTML> Mon, 23 Jun 2014 11:35:23 GMT https://community.qlik.com/t5/QlikView/count-monthyear/m-p/727933#M260866 MK_QSL 2014-06-23T11:35:23Z Re: count monthyear https://community.qlik.com/t5/QlikView/count-monthyear/m-p/727934#M260867 <HTML><HEAD></HEAD><BODY><P>Hi Yarin</P><P></P><P></P><P>count(monthyear)&nbsp; will count every record and display the number of records according to your selection</P><P></P><P>what do you need ?&nbsp; may be a count(distinct monthyear)&nbsp; ?</P><P>Chris</P></BODY></HTML> Mon, 23 Jun 2014 11:39:29 GMT https://community.qlik.com/t5/QlikView/count-monthyear/m-p/727934#M260867 2014-06-23T11:39:29Z