Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
Creator
Creator

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

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

class.PNG

Creator
Creator

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