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

shabarish0587 — Wed, 14 Apr 2021 15:18:59 GMT

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.

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

MayilVahanan — Thu, 15 Apr 2021 08:44:16 GMT

Hi @shabarish0587

Try like below in listbox

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

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

shabarish0587 — Thu, 15 Apr 2021 11:48:24 GMT

Thank you Mayil Vahanan

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

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

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

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