for example like this:
=Aggr(If(Sum(sales)>vSalesBandMax,Dual(vSalesBandMax&'+',vSalesBandMax),Dual(Replace(Class(Sum(sales),500),'<= x <','-'),Class(Sum(sales),500))),client)
given this data:
tabSales: LOAD Date(YearStart(Today())+Floor(Rand()*DayNumberOfYear(Today()))) as date, Chr(65+Floor(Rand()*2))&Chr(65+Floor(Rand()*26)) as client, Money(Ceil(Rand()*1000)) as sales AutoGenerate 100;
hope this helps
QlikCommunity_Thread_140506.qvw 161.2 K
This is brilliant, exactly what I was looking for. Just one last quick question.
I have another field in my data which which tells me the type of business i.e. "New Business" or "Existing". How would I adjust the calculated condition if I wanted to look at purely the "New Business?