1 Reply Latest reply: Mar 12, 2012 8:14 PM by Stefan Wühl RSS

    Calculated Dimension to Create Groups

      I am new to Qlikbook and I am having difficulty returning the correct sum of the quantity sold by customer.  I am trying to break the quantity purchased by customer into brackets (<12, 12-19, 20-29, etc) by Year.

       

      Dimensions

       

      I am using the following Dimensions - Calculated Dimension, Year

       

      Here is the calculated dimension expression that I created. (QVOF = Quantity)

       

      =If((QVOF<12),'<12',If((QVOF>=12 and QVOF<20),'12-19',If((QVOF>=20 and QVOF<30),'20-29',If((QVOF>=30 and QVOF<40),'30-39',If((QVOF>=40 and QVOF<80),'40-79','80+')))))

       

      Expressions

       

      sum(QVOF)

       

      I am then graphing the data by Year

       

      Do I need to use the AGGR function?