Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

zagzebski
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
zagzebski
Contributor

Re: Aggr small amounts

Thanks!

Community Browser