Discussion Board for collaboration related to Creating Analytics for QlikView.
For example, I have a table that looks like this:
I would like to classify the sales person based on their total sales performance, i.e.
What formula should I use as the dimension for the classification?
I have tried =class(aggr(distinct sum(Sales),SalesPerson),5) but it does not work, nothing came up.
Check Enclosed File...!!!
View solution in original post
I tried your function and seems to work, see the attached file
there is a missing space in the aggr [sales person]
Thanks for helping @Michele Barini. There was a typo error on 'sales person' above actually. I think the formula works for this simple example.
However the actual data I'm dealing is slightly more complicated which involves a key, which will be linked to two other tables.
Table 1: Sales Table
Table 2: Purchase Table
Table 3: Key Table
For this question we will not involve Table 2, I'm showing it to demonstrate all the relationships.
In this case, how should the formula be like?
Manish Kachhia Thank you so much! This solves my question.
=DUAL(Replace(Aggr(Class(SUM(Sales),5),SalesPerson),'<= x <', '-'),Aggr(Class(SUM(Sales),5),SalesPerson))
Also is there anyway to limit the minimum/maximum value for the class, i.e. such that anything larger than 10 will be in one class?
Possible... Just change the Calculated Dimension as below
IF(Aggr(SUM(Sales),SalesPerson)>=5 and Aggr(SUM(Sales),SalesPerson)< 9 , '5-9',
IF(Aggr(SUM(Sales),SalesPerson)>=5 and Aggr(SUM(Sales),SalesPerson)< 9 , 2,