Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
bashar_f
Partner - Creator
Partner - Creator

Use dynamically populated listbox to select ranges

Hi there,

I have an input box that has the following variables:-

Range 1 = 0

Range 2 = 500

Range 3 = 501

Range 4 = 1000

Range 5 =1001

Range 6 =1500

Range 7 =1501

Range 8 =2000

Range 9 =2001

Range 10 =3000

I'd like to have a list box that is populated with the above variables as follows when the user enters the ranges in the input box


Range 1 - Range 2             

Range 3 - Range 4             

Range 5 - Range 6               

Range 7 - Range 8

Range 9 - Range 10


I'd also like to select from the dynamically populated list box and i want it to reflect on a 2nd list box called Salary.


Load * Inline

[Salary

300

500

900

1000

1400

2000

2600

3000

]


So, if for example, the user enters Range 1 = 0, Range 2 = 500 and i select that, then only 300 and 500 would show up in the salary list box. is this doable? I tried using the Class function, but it has a fixed width, what i want to do is allow the user to specify the width for each line in the Ranges list box.


Any help is much appreciated.

11 Replies
tresesco
MVP
MVP

May be I am missing something. At a time, a user would wish to have/select one range, right? If he/she needs other range, just have to re-input a different range. Isn't it?

bashar_f
Partner - Creator
Partner - Creator
Author

Well, yes, but the user would like to have his own custom list of ranges

for example

200 - 800

1000 - 1500

1800 - 1900

2000 - 2700

3100 - 3200

200 being Range 1, 800 being Range 2, etc

as you can see, with this, salaries with 900 will never appear because there is no selection that includes 900,  same goes for 1600,1700. The the ability to customize their range listbox.