topic Re: Use dynamically populated listbox to select ranges in QlikView

Use dynamically populated listbox to select ranges

bashar_f — Sun, 20 Sep 2015 22:20:13 GMT

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.

Re: Use dynamically populated listbox to select ranges

tresB — Mon, 21 Sep 2015 06:10:54 GMT

May be like attached sample?

Re: Use dynamically populated listbox to select ranges

Digvijay_Singh — Mon, 21 Sep 2015 06:25:30 GMT

As you started like - 'I have an input box that has the following variables' . Did you mean like this -

Can you elaborate how you are selecting multiple ranges in the beginning? Can you select like 0 to 1500 , and if yes then how?

Re: Use dynamically populated listbox to select ranges

bashar_f — Mon, 21 Sep 2015 06:47:57 GMT

Hi tresesco,

Thanks so much for the reply

This looks great! but would it be possible in the Range Listbox to have the value of the ranges written instead of the words Range1, Range2, etc...

Also, could you please add the functionality for the rest of the ranges in the expression in the salary listbox? I tried, but there is an error.

I'm sorry, but i'm still a beginner.

Re: Use dynamically populated listbox to select ranges

Kushal_Chawda — Mon, 21 Sep 2015 06:48:41 GMT

You can create the slider instead of 10 variable to select the range.

Or using input box with two variables ( From and To) you can populate your variable

see the attached

Re: Use dynamically populated listbox to select ranges

bashar_f — Mon, 21 Sep 2015 06:52:22 GMT

Hi Digvijay,

yes, that's pretty much it.

we'd like the user to populate the selections in the ranges list box, so basically, he can write 0 in the vRange1 and 1500 in vRange2, which will result in having the first row = 0 - 1500, and he can select that and it will reflect on Salaries listbox.

Please don't hesitate if you'd like me to explain more.

Re: Use dynamically populated listbox to select ranges

bashar_f — Mon, 21 Sep 2015 07:03:40 GMT

Hi Kush141087,

Thanks for the reply,

This is a great idea, except the width is not always fixed, which is why i'm putting 10 variables so that the user can have his custom list of ranges like the following

for example

200 - 800

1000 - 1500

1800 - 1900

2000 - 2700

3100 - 3200

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. tresesco up above is on the right track.

Re: Use dynamically populated listbox to select ranges

tresB — Mon, 21 Sep 2015 07:13:12 GMT

Why don't you use just two variables/inputs (say, To/From) that users input their range and gets data accordingly?

Re: Use dynamically populated listbox to select ranges

bashar_f — Mon, 21 Sep 2015 07:15:54 GMT

Because then the width would be the same for all the ranges, so we're giving the user the capability of customizing the width for each range.

Re: Use dynamically populated listbox to select ranges

Kushal_Chawda — Mon, 21 Sep 2015 07:26:26 GMT

Then i think you can go for what tresesco has suggested

Re: Use dynamically populated listbox to select ranges

tresB — Mon, 21 Sep 2015 07:31:57 GMT

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?

Re: Use dynamically populated listbox to select ranges

bashar_f — Mon, 21 Sep 2015 07:41:01 GMT

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.