Expression Issue

sibin_jacob — Tue, 12 Mar 2013 18:19:49 GMT

Hai,

I am keeping all the data at district level. I need to know the count of districts having value less than Nation value.

I am keeping nation value in one variable.

I need count of distinct district having the value less than nation,

For example

My district values are

Dis1 - 20

Dis2 - 40

Dis3 - 15

Dis4 - 22

Dis5 - 21

Dis6 - 35

My nation value is vNation=25

So I need count(District)= 4

Please tell me the expression for finding count compare with some value..

And also I need the list of districts having lesser value compare with nation

ex:- Dis1, Dis3, Dis4, Dis5

Thanks,

Sibin Jacob.C

topic Expression Issue in QlikView