Purchases per customer

[21015137]

Hi all!

I am very new to Qlik and can't figure out how to make a graph that seems simple in my head. I am trying to display how many purchases customers have made. I have product keys, order numbers and customer keys but getting them to work together is proving difficult.

There may well be a very simple solution that I have not yet grasped! Any help would be very much appreciated.

Thank you!

[sidhiq91]

@21015137 As per your requirement, it should be something as below: 

In a bar chart:

Dimension: Customer Key OR Customer Name

Measure: Count(distinct Order Number)

Let me know if this is something that you were looking for.

[21015137]

I think this looks correct, thank you!

Would you also happen to know how to go about making it so that instead of having a bar for each customer key, it will, for example, say there are 4 customers who made 10 purchases, 3 customers who made 20 purchases etc.? 

[sidhiq91]

@21015137  I can help you out with that, could you please provide some sample data?

[21015137]

Thanks! I've attached a section from one of the sheets which I think is all that will be needed.

This is for a project so none of the data is real or sensitive