Discussion Board for collaboration on QlikView Layout & Visualizations.
I want to aggragate products that have had sales less than a certain amount into one bucket in a chart.
Sales of Product A - 50
Sales of Product B - 60
Sales of Product C - 70
Sales of Product D - 80
Sales of Product E - 1
Sales of Product F - 2
How would I write a calculated dimension that would group any product with sales under 10 into one combined product and if it is over 10 they just remain the same?
The results in the chart:
Sales of Combined Products < 10 - 3
Go to Solution.
Something like this:
calculated dimension: if(aggr(sum(Sales)),Product)<10, 'Combined Product', Product)
replace Sales and Product with your field names