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: 
Not applicable

Help counting/charting occurrences within data

Hello,

I have a transaction file with two fields: CustomerID and ItemID. Each line represents a single order/transaction, so a customer ID can show up multiple times. My thought was there would be a way to count/show the distribution of how many customers made 1 order, 2 orders, 3 orders, 4 orders, 5 orders...N orders. What I would like is a histogram/bar chart that details this (so first bar would be number of customers that made 1 order, second would be # of customers that made 2 orders, and so on). I have been playing around for a half day trying to figure it out and can't seem to get it. I'm pretty new so any help would be much appreciated!

Thanks!

7 Replies
Gysbert_Wassenaar

You need a calculated dimension for this =aggr(count(ItemID),CustomerID). And the expression to go with that is count(distinct CustomerID).


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert. Thanks for this. The chart almost looks perfect, however, it seems that I am missing something as it just lumps a single total into one bar? Do I have to set parameters to delineate multiple bars?

Gysbert_Wassenaar

You'll have to show me a qlikview document that shows what you mean. I don't see how it could do that.


talk is cheap, supply exceeds demand
Not applicable
Author

My bad! I put Class instead of Count. It works now Thank you!!

Gysbert_Wassenaar

Haha . Glad you sorted it.


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

Thanks for your help. I have one follow up question. Since I now have a nice graph which shows customers by number of orders and another graph of sales volume by number of orders, I'd like to be able to slice and dice the rest of my dashboard/metrics by number of orders made. I believe I need to create a list box for the number of orders. I tried playing around with it but wasn't able to figure out how to do this. Is this possible? If so, do you know how I can do that?

Thanks again for helping a new guy out. I'm looking to take some formal training on this ASAP but for now your help is invaluable.

Gysbert_Wassenaar

New question, new discussion please. These two documents are worth reading too:

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling


talk is cheap, supply exceeds demand