topic Re: Class function negative values under one bucket in QlikView https://community.qlik.com/t5/QlikView/Class-function-negative-values-under-one-bucket/m-p/26447#M4410 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>=Aggr(If(Sum(Invoices) &lt; 0, '&lt; 0', Class(Sum(Invoices), 1000000, '$')), [Invoice Number])</STRONG></P></BODY></HTML> Wed, 28 Mar 2018 16:36:06 GMT sunny_talwar 2018-03-28T16:36:06Z Class function negative values under one bucket https://community.qlik.com/t5/QlikView/Class-function-negative-values-under-one-bucket/m-p/26446#M4409 <HTML><HEAD></HEAD><BODY><P>Hi Guru's,</P><P></P><P>i want to create invoice Buckets based on the Invoice amount.</P><P></P><P>i want to group Minus Buckets into one bucket.</P><P></P><P>how to achieve this.</P><P></P><P>Please find the attached Qvw and screen shot</P><P></P><P></P><P>Thanks,</P><P>raj</P></BODY></HTML> Wed, 28 Mar 2018 16:32:44 GMT https://community.qlik.com/t5/QlikView/Class-function-negative-values-under-one-bucket/m-p/26446#M4409 Anonymous 2018-03-28T16:32:44Z Re: Class function negative values under one bucket https://community.qlik.com/t5/QlikView/Class-function-negative-values-under-one-bucket/m-p/26447#M4410 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>=Aggr(If(Sum(Invoices) &lt; 0, '&lt; 0', Class(Sum(Invoices), 1000000, '$')), [Invoice Number])</STRONG></P></BODY></HTML> Wed, 28 Mar 2018 16:36:06 GMT https://community.qlik.com/t5/QlikView/Class-function-negative-values-under-one-bucket/m-p/26447#M4410 sunny_talwar 2018-03-28T16:36:06Z