Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sibin_jacob
Creator III
Creator III

Expression Issue

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

0 Replies