topic Frequency Sales Graph in QlikView https://community.qlik.com/t5/QlikView/Frequency-Sales-Graph/m-p/229372#M81301 <HTML><HEAD></HEAD><BODY><P>Maybe vice versa, if you need to see number of sales per Member. The expression should be like this:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=aggr(Count(Sales),MemberNo)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Wed, 21 Jul 2010 14:27:52 GMT 2010-07-21T14:27:52Z Frequency Sales Graph https://community.qlik.com/t5/QlikView/Frequency-Sales-Graph/m-p/229371#M81300 <HTML><HEAD></HEAD><BODY><P>Hey guys.</P><P>I needa create a Frequency sales Graph that depicts the frequency of sales over a MonthYear dimension.</P><P>I set my expression as</P><P>=aggr(Count(MemberNo),Sales)</P><P>but its not working.</P><P>Any ideas?</P><P>Thanks in advanced</P></BODY></HTML> Wed, 21 Jul 2010 14:22:53 GMT https://community.qlik.com/t5/QlikView/Frequency-Sales-Graph/m-p/229371#M81300 2010-07-21T14:22:53Z Frequency Sales Graph https://community.qlik.com/t5/QlikView/Frequency-Sales-Graph/m-p/229372#M81301 <HTML><HEAD></HEAD><BODY><P>Maybe vice versa, if you need to see number of sales per Member. The expression should be like this:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=aggr(Count(Sales),MemberNo)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Wed, 21 Jul 2010 14:27:52 GMT https://community.qlik.com/t5/QlikView/Frequency-Sales-Graph/m-p/229372#M81301 2010-07-21T14:27:52Z Frequency Sales Graph https://community.qlik.com/t5/QlikView/Frequency-Sales-Graph/m-p/229373#M81302 <HTML><HEAD></HEAD><BODY><P>Thanks for the quick response.</P><P></P><PRE>=aggr(Count(Sales),MemberNo) isnt working...</PRE><PRE>any other ideas?</PRE><BR /><BR /></BODY></HTML> Wed, 21 Jul 2010 14:29:03 GMT https://community.qlik.com/t5/QlikView/Frequency-Sales-Graph/m-p/229373#M81302 2010-07-21T14:29:03Z Frequency Sales Graph https://community.qlik.com/t5/QlikView/Frequency-Sales-Graph/m-p/229374#M81303 <HTML><HEAD></HEAD><BODY><P>I think there is no need for aggr() function if you wanted to see the frequency. you just need to define the dimension (i.e. MonthYear) and the expression (i.e. =count(Sales) )</P><P>Regards<BR />Shumail Hussain</P></BODY></HTML> Wed, 21 Jul 2010 14:36:09 GMT https://community.qlik.com/t5/QlikView/Frequency-Sales-Graph/m-p/229374#M81303 shumailh 2010-07-21T14:36:09Z Frequency Sales Graph https://community.qlik.com/t5/QlikView/Frequency-Sales-Graph/m-p/229375#M81304 <HTML><HEAD></HEAD><BODY><P>lol cnt believe it...thaks for your help man</P></BODY></HTML> Wed, 21 Jul 2010 14:37:52 GMT https://community.qlik.com/t5/QlikView/Frequency-Sales-Graph/m-p/229375#M81304 2010-07-21T14:37:52Z