Discussion board where members can get started with Qlik Sense.
Input are sales per sales-rep and date.
I want to divide them into certain value-groups according to their sale-volume (e.g. 1 - 10.000, 10.001 - 50.000, etc.) and then show group-sums (count and value).
E.G. in group 1 - 10.000 are 30 invoices with a total sales of 50.000.-
How can I do that ?
You could try something like:
if(aggr(Sum(Sales), id_sales_rep) >= 1 and aggr(Sum(Sales), id_sales_rep) < 1000, 'Group 1', 'Group 2')
You can extend the number of groups by creating new conditions.
I recommend you to create a master item in order to reuse the new dimension within your app.
I hope it helps,
I assume, this has to be done in the data-editor, when inputting the data into qs ?
You would say you have three options in this case:
1. You can add a dimension to your chart and write your expression, as follows:
2. You can create a new dimension as a 'Master Item', so you do not have to copy and paste the expression every time you want to use the dimension (see Qlik Sense Desktop -- Using The Master Library - YouTube):
*Note that the master item is limited to your app
3. Or you can create a new column in the load script.
I personally tend to use IntervalMatch approaches as they handle 'gaps' (buckets with no records in them)