topic Creating Deal Bands as Dimensions - Load Editor or Calculated Dimension? in App Development https://community.qlik.com/t5/App-Development/Creating-Deal-Bands-as-Dimensions-Load-Editor-or-Calculated/m-p/1227013#M23921 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P>I've been trying to research this over the last couple days without any luck.&nbsp; I've attached an Excel file to illustrate what I am trying to accomplish via Qlik.</P><P></P><P>I am trying to create a dimension within my model for Deal Size Bands, i.e &gt;$1M, $500k-$1M, $250k-$500k, etc.&nbsp; Unfortunately, this is challenging because the revenue data I am working with can have one deal spread across multiple rows.&nbsp; As a result, I basically need to create deal band buckets based on the distinct sum of a given row.</P><P></P><P>Any help would be greatly appreciated!</P><P></P><P>Thanks,</P><P>Brian</P></BODY></HTML> Tue, 07 Feb 2017 14:50:49 GMT 2017-02-07T14:50:49Z Creating Deal Bands as Dimensions - Load Editor or Calculated Dimension? https://community.qlik.com/t5/App-Development/Creating-Deal-Bands-as-Dimensions-Load-Editor-or-Calculated/m-p/1227013#M23921 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P>I've been trying to research this over the last couple days without any luck.&nbsp; I've attached an Excel file to illustrate what I am trying to accomplish via Qlik.</P><P></P><P>I am trying to create a dimension within my model for Deal Size Bands, i.e &gt;$1M, $500k-$1M, $250k-$500k, etc.&nbsp; Unfortunately, this is challenging because the revenue data I am working with can have one deal spread across multiple rows.&nbsp; As a result, I basically need to create deal band buckets based on the distinct sum of a given row.</P><P></P><P>Any help would be greatly appreciated!</P><P></P><P>Thanks,</P><P>Brian</P></BODY></HTML> Tue, 07 Feb 2017 14:50:49 GMT https://community.qlik.com/t5/App-Development/Creating-Deal-Bands-as-Dimensions-Load-Editor-or-Calculated/m-p/1227013#M23921 2017-02-07T14:50:49Z