how to filter the drop down

[kunkumnaveen]

Hello All,

How to filter the drop down,in the attachment

from the top drop down i selected :CLZ

the requirement  i looking is,when i select clz the bottom drop down has to show only those values which comes under clz

u can see in the attachment  the top four are colored in white so i want to  show only those 4 four when i select clz not the rest

how i am going to achieve this task

thanks

naveen

[nagireddy_qv]

HI

Just check the  hide excluded option in the list box..

[Gysbert_Wassenaar · Accepted solution]

Replace the field of the second listbox with an expression. Instead of Name use =aggr(only({<Location=P(Location)>}Name),Name)

[kunkumnaveen]

Hello Gysbert ,

Thanks man it is working...great work man appreciated

[kunkumnaveen]

Hello Gysbert...Thanks for giving your input man,which is working fine but the thing is it possible to make it more user friendly wise let say this way

LEVEL 1:

location :clz(selected from drop down)

Name:   hydro1

             chanderia cpp

              chanderia zinc

this is want i need and i am getting my requirement

LEVEL 2:(need more user friendly)

currently what i am getting is

   location :clz

   Name :hydro1(selecting one value from the three values)

so at this stage what happening, is when i want to choose different Name: chanderia cpp of same location to achieve this currently what i need to do is

step 1.I need to press clearAll button

step 2. Again.Again i need to select  location

step 3. Then again from the Name field drop down i need to choose required value

so  my concern is at level 2 if i  need to select different name of same location instead of repeating STEP 1 and STEP 2 is it possible straight to achieve  STEP 3 ..

SORRY i am not able to attach the document ,the option is invisible ......

thanks

naveen

[Gysbert_Wassenaar]

Try this: =aggr(only({<Name=,Location=P(Location)>}Name),Name)

[kunkumnaveen]

Hello Gysbert,

I tried your second expression but it doesn't make any impact it remain same ,i mean still to select again at level 2

i need to follow those STEP1 and STEP 2 which i dont want to do

thanks

naveen