0 Replies Latest reply: Feb 7, 2017 9:50 AM by Brian Ammidown RSS

    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