How to find specific number of districts in State.

[dathathreya]

Hi all,

I am not able to get top districts in state wise.

My requirement is in india took all states .in each state we will have lot of districts.in this now which state is having more than 10 districts i want to get state in list box.on frontend end i want to get.

Plz Help me our.

[Anil_Babu_Samineni · Accepted solution]

If you want to load 10 distinct values in front end simple answer no, But if you try with Expression and Dimension in straight table with some work around you will get it to work

If not, Another approach is create autonumber() for that distinct field and use it autonumber field in front end

[pradosh_thakur]

something like in a list box use expression like below

if(aggr(count(distinct district),state)>=10 ,state,null())

replace district and state as your field name

regards

Pradosh

[dathathreya]

if i use your expression then i will get state but i have to display districts also

[vvvvvvizard]

listbox expression

if (aggr(count(district)>10,state),district) ,district)

[dathathreya]

small modification in your expression yusuuf

if(aggr(count(district)>10,State),district).

if i use this expression i will get only the first district in that state ,the remaining states are not able to display.

plz help me to get all districts .