Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Class Function, limit the groups

Hello, is it possible to limit the amount of groups the class function generates? I have a large amount of data of customers and products and the percent of returns,this is the value to class and goes to -10,000% to 10,000% but the user only want few groups with the count of clients and products that fall in each range ( < 0%,0-10%,10%-20%,20-30%....>100%) , so when using the class function generates lots of groups (-10,000 % <= x <= -9,900%).

I tried to use set analysis instead but it's pretty difficult to control but sides of the information  (clients attributes and product attributes), and time  and the way the user wants to navigate (select client's attributes and then see how the client's products fall in each range to detect which have more returns, select more than one month to evaluate), so i believe the best option would be the class function but how to make it work with this?

Any help would be appreciate!

1 Reply
Gysbert_Wassenaar

Use an if statement to restrict the values you want to class.

If( Value < 0, '<0%', if(Value > 1, '>100%', Class(Value,0.1)))


talk is cheap, supply exceeds demand