Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
aetingu12
Creator
Creator

Creating banding based on Count of Customers aggregated by Sales

Dear all,

I am looking to create a table with sales bandings, <1000, >=1000 and <2000 etc as my dimension and the count of customers for each of these dimensions.  How do I go about creating this?

I have attached as sample sheet. (I need to do this on the front end and not scripting it)

Thanks in advance,

Aksel

Labels (3)
1 Solution

Accepted Solutions
aetingu12
Creator
Creator
Author

Thank you very much.  I tried another formula and it seems like it is giving me what I am looking for.  However not sure why yours and mine vary.

Dimension I use is:

=Aggr(if(sum({<Customer>}Sales)<1000, dual('<1000',1),
if(sum({<Customer>} Sales)>=1000 and sum({<Customer>} Sales)<2000, dual('1000-2000',2),dual('2000+',3)))
,Customer) 

Giving me:

Screenshot 2020-07-13 at 19.52.17.png

View solution in original post

2 Replies
jwjackso
Specialist III
Specialist III

Check the  Class function.  Using your data, see the results below:

class.PNG

aetingu12
Creator
Creator
Author

Thank you very much.  I tried another formula and it seems like it is giving me what I am looking for.  However not sure why yours and mine vary.

Dimension I use is:

=Aggr(if(sum({<Customer>}Sales)<1000, dual('<1000',1),
if(sum({<Customer>} Sales)>=1000 and sum({<Customer>} Sales)<2000, dual('1000-2000',2),dual('2000+',3)))
,Customer) 

Giving me:

Screenshot 2020-07-13 at 19.52.17.png