topic how to write set expression for the given situation in QlikView

how to write set expression for the given situation

Fri, 03 Feb 2017 17:24:47 GMT

I want to get count of id whose sum(dollar)<15. how to write set expression for it???

for example : sum(dollar)< 15 is:

id= 4 , sum(dollar)=7

id=3, sum(dollar)=14

so these are less than 15 . so output should be 2.

vishsaggi — Fri, 03 Feb 2017 17:46:33 GMT

Try this?

Your Dim as ID

and Expr as = Sum({<ID = {"=Sum(dollar) < 15"} >}dollar)

surendraj — Fri, 03 Feb 2017 18:03:28 GMT

This will fit your requirement...

AGGR(Sum({<ID = {"=Sum(DOLLAR) < 15"} >}DOLLAR),ID)

Thanks,

Surendra.

maxgro — Fri, 03 Feb 2017 18:48:03 GMT

In a text box

=count(

{$ < id={"=sum(dollar)<15"} >}

distinct id)

Sat, 04 Feb 2017 05:55:59 GMT

thanks a lot , very helpful