Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
21015137
Contributor
Contributor

Purchases per customer

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!

Labels (5)
4 Replies
sidhiq91
Specialist II
Specialist II

@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
Contributor
Contributor
Author

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
Specialist II
Specialist II

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

21015137
Contributor
Contributor
Author

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