Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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