How to use Input Box data reflected into List box in Qlikview

[shabarish0587]

Hi Folks,

                I am facing a issue using Input Box. can any one please help me on this. Actually i have few columns like  ID, Date, Days and Name. Here my requirement is i need to enter the values from Input box for days.

                It Means if we give  8 from Input box. it should display all the days data greater than 8 in the chart and also it should reflect  Name in list box also.

         For Eg: i Have days like 7,8,9,10,11, in Input box if i give 8 then it should display the data  greater than 8 like 8,9,10,11...  along with Names can reflect in List box as Vamsi, Ravi, Sankhar, Mahesh like that. 

               For this i have written like this Only({<Days={">$(vDays)"}>} Days) this one is working fine for Tables. But same thing i tried in Listbox but it is not working.  I want to display Name filter data while giving the value from the input box. 

            I am sharing sample excel file. Can anyone help me on this. 

[MayilVahanan · Accepted solution]

Hi @shabarish0587 

Try like below in listbox

=Aggr(Only({<Days={">$(vDays)"}>} Name),Name)

[shabarish0587]

Thank you Mayil Vahanan