topic Re: Greater Than Less Than In One Set Expression in QlikView

Greater Than Less Than In One Set Expression

Anonymous — Fri, 05 Dec 2014 22:13:53 GMT

Trying to get Sum of Sales here Sales for each client is between 1,000 and 1,000,000

1. This one doesn't work:
Sum(Aggr(Sum({<Client={"=Sum(Sales)>=1000<1000000"}>} Sales) , Client))

2. This works partially, meaning also includes Clients with Sales lower than 1,000:

Sum(Aggr(Sum({<Client={"=Sum(Sales)>=1000"}, Client={"=Sum(Sales)<1000000"}>} Sales) , Client))

Any suggestions ?

Thanks.

MK_QSL — Fri, 05 Dec 2014 23:21:36 GMT

=SUM({<Client = {"=SUM(Sales) >= 1000 and SUM(Sales) <= 1000000"}>}Sales)

Anonymous — Sat, 06 Dec 2014 00:01:44 GMT

Thank you.