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

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

    Brian Ammidown

      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