topic Re: how to filter the drop down in QlikView

how to filter the drop down

kunkumnaveen — Thu, 18 Feb 2016 11:14:00 GMT

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

Re: how to filter the drop down

nagireddy_qv — Thu, 18 Feb 2016 17:35:41 GMT

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

Re: how to filter the drop down

Gysbert_Wassenaar — Thu, 18 Feb 2016 17:49:23 GMT

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

Re: how to filter the drop down

kunkumnaveen — Fri, 19 Feb 2016 04:48:58 GMT

Hello Gysbert ,

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

Re: how to filter the drop down

kunkumnaveen — Fri, 19 Feb 2016 06:17:40 GMT

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

Re: how to filter the drop down

Gysbert_Wassenaar — Fri, 19 Feb 2016 09:12:21 GMT

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

Re: how to filter the drop down

kunkumnaveen — Fri, 19 Feb 2016 09:31:06 GMT

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