Bar Chart displaying Frequency

[#1]

Dear Community,

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.

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.

All the best,

Eva

[Gysbert_Wassenaar]

Create a chart with a calculated dimension =aggr(count(distinct products),[Customer ID]). Use count(distinct [Customer ID]) as expression.

[#3]

Thank you so much! That's what I had, but I forgot the distinct. Now it works! 😃