Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

how to filter the drop down

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

1 Solution

Accepted Solutions

Re: how to filter the drop down

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


talk is cheap, supply exceeds demand
6 Replies
nagireddy_qv
Contributor II

Re: how to filter the drop down

HI

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

Re: how to filter the drop down

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


talk is cheap, supply exceeds demand
kunkumnaveen
Contributor III

Re: how to filter the drop down

Hello Gysbert ,

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

kunkumnaveen
Contributor III

Re: how to filter the drop down

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 2Smiley Sadneed 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

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


talk is cheap, supply exceeds demand
kunkumnaveen
Contributor III

Re: how to filter the drop down

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

Community Browser