topic Re: Bar Chart displaying Frequency in QlikView https://community.qlik.com/t5/QlikView/Bar-Chart-displaying-Frequency/m-p/899739#M1015504 <HTML><HEAD></HEAD><BODY><P><BR />Thank you so much! That's what I had, but I forgot the distinct. Now it works! <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P></BODY></HTML> Thu, 16 Apr 2015 07:09:11 GMT 2015-04-16T07:09:11Z Bar Chart displaying Frequency https://community.qlik.com/t5/QlikView/Bar-Chart-displaying-Frequency/m-p/899737#M1015502 <HTML><HEAD></HEAD><BODY><P>Dear Community,</P><P></P><P>i'm rather new to qlikview and i'm having this problem right now. I have a dimension 'products' with different products (A, B, C, ...) and 'Customer ID'. In a first step, a have a table showing for each customer how many products they bought (with a simple count expression). Now I want to create a bar chart showing the frequency distribution of that, meaning how many customers bought 30 products, how many bought 21, how many bought 19 and so on.</P><P></P><P>Does anyone have any idea or suggestion on how I might achieve that? I have been trying for hours, but I also find it very hard to google that, so hope, someone here can help me out.</P><P></P><P>All the best,</P><P>Eva</P></BODY></HTML> Mon, 13 Apr 2015 06:45:52 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-displaying-Frequency/m-p/899737#M1015502 2015-04-13T06:45:52Z Re: Bar Chart displaying Frequency https://community.qlik.com/t5/QlikView/Bar-Chart-displaying-Frequency/m-p/899738#M1015503 <HTML><HEAD></HEAD><BODY><P>Create a chart with a calculated dimension =aggr(count(distinct products),[Customer ID]). Use count(distinct [Customer ID]) as expression.</P></BODY></HTML> Mon, 13 Apr 2015 12:24:24 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-displaying-Frequency/m-p/899738#M1015503 Gysbert_Wassenaar 2015-04-13T12:24:24Z Re: Bar Chart displaying Frequency https://community.qlik.com/t5/QlikView/Bar-Chart-displaying-Frequency/m-p/899739#M1015504 <HTML><HEAD></HEAD><BODY><P><BR />Thank you so much! That's what I had, but I forgot the distinct. Now it works! <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P></BODY></HTML> Thu, 16 Apr 2015 07:09:11 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-displaying-Frequency/m-p/899739#M1015504 2015-04-16T07:09:11Z