Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
shabarish0587
Contributor
Contributor

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

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. 

1 Solution

Accepted Solutions
MayilVahanan

Hi @shabarish0587 

Try like below in listbox

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

MayilVahanan_0-1618476247870.png

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

2 Replies
MayilVahanan

Hi @shabarish0587 

Try like below in listbox

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

MayilVahanan_0-1618476247870.png

 

Thanks & Regards,
Mayil Vahanan R
shabarish0587
Contributor
Contributor
Author

Thank you Mayil Vahanan