Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Class function negative values under one bucket

Hi Guru's,

i want to create invoice Buckets based on the Invoice amount.

i want to group Minus Buckets into one bucket.

how to achieve this.

Please find the attached Qvw and screen shot

Thanks,

raj

1 Solution

Accepted Solutions
sunny_talwar

Try this

=Aggr(If(Sum(Invoices) < 0, '< 0', Class(Sum(Invoices), 1000000, '$')), [Invoice Number])

View solution in original post

1 Reply
sunny_talwar

Try this

=Aggr(If(Sum(Invoices) < 0, '< 0', Class(Sum(Invoices), 1000000, '$')), [Invoice Number])