topic How to write set analysis in expression in QlikView

How to write set analysis in expression

jagannalla — Fri, 25 Mar 2011 14:06:58 GMT

I am writing the expressions like this to get small,medium,large.

For small---> Count({$<Size={"<$(vLBound)"}>} Debris) i,e Size <= A

For Large ----> Count({$<Size={">$(vUBound)"}>} Debris) i.e Size >=B

How can i write the expression for medium ? i.e A < Size < B

pover — Fri, 25 Mar 2011 14:20:10 GMT

Try something like this:

Count({$<Size={">$(vLBound)<$(vUBound)"}>} Debris)

Regards.

jagannalla — Fri, 25 Mar 2011 14:55:34 GMT

Thanks for u r solution.....it's working