# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Contributor

## Aggr small amounts

I want to aggragate products that have had sales less than a certain amount into one bucket in a chart.

Ex.

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 Product A - 50

Sales of Product B - 60

Sales of Product C - 70

Sales of Product D - 80

Sales of Combined Products < 10 - 3

1 Solution

Accepted Solutions

## Re: Aggr small amounts

Something like this:

calculated dimension: if(aggr(sum(Sales)),Product)<10, 'Combined Product', Product)

expression: sum(Sales)

replace Sales and Product with your field names

talk is cheap, supply exceeds demand
2 Replies

## Re: Aggr small amounts

Something like this:

calculated dimension: if(aggr(sum(Sales)),Product)<10, 'Combined Product', Product)

expression: sum(Sales)

replace Sales and Product with your field names

talk is cheap, supply exceeds demand
Contributor

Thanks!