6 Replies Latest reply: Jun 13, 2018 9:03 AM by jerry Ogwa RSS

    How to aggerate records based on value of an attribute

    Anthony Richardson

      i know that Qlik aggerates within the data sheets records where attributes are common. what i need is to control that based on a condition. if the value is less than 150K then aggergate then if not split them out.  example below i need FA862517C2001 to show up as 1 record with their totals sumed together.  The othe duplicate Contract Numbers are greate than 150K so the need to be seperated.

       

      thank you

      Picture1.png