Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dathathreya
Creator
Creator

How to find specific number of districts in State.

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.

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

5 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pradosh_thakur
Master II
Master II

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

Learning never stops.
dathathreya
Creator
Creator
Author

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

vvvvvvizard
Partner - Specialist
Partner - Specialist

listbox expression

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

dathathreya
Creator
Creator
Author

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 .