Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
@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.
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.?
@21015137 I can help you out with that, could you please provide some sample data?
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