Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-02-07 09:50 AM

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

Deal Band Example.xlsx
924 Views
0 Likes
0 Replies