Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Creating Deal Bands as Dimensions - Load Editor or Calculated Dimension?

Hello all,

I've been trying to research this over the last couple days without any luck.  I've attached an Excel file to illustrate what I am trying to accomplish via Qlik.

I am trying to create a dimension within my model for Deal Size Bands, i.e >$1M, $500k-$1M, $250k-$500k, etc.  Unfortunately, this is challenging because the revenue data I am working with can have one deal spread across multiple rows.  As a result, I basically need to create deal band buckets based on the distinct sum of a given row.

Any help would be greatly appreciated!