Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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!

Thanks,

Brian

0 Replies