topic Re: Button to select values from a list box in QlikView

Button to select values from a list box

Thu, 29 Oct 2015 09:06:42 GMT

Hi Experts,

I have a requirement where based on two input boxes(min and max) values should get selected from a listbox.

I have set the values of variables and modified short charts and tables and on click, the data is changing.

But, there are too many charts and also, some expressions are quite complex and fitting the formula in all charts is not becoming possible.

Is there a way, that once I set values for the min and max input boxes and hit enter, the in between values get selected by default from the list box. This would automatically drill-down the data in all tabs and serve my purpose.

As of now, I am able to populate a listbox with just the in between values and these values need to selected manually. I want these to be selected automatically.

Thanks in advance.

Regards,

Nayana

Re: Button to select values from a list box

swuehl — Thu, 29 Oct 2015 09:19:40 GMT

Try a button with an Select - Select in field Action

Field Name should be your field used in the list box.

Then, as search string use something like

='>$(min)<$(max)'

where min and max are your two variables you are using to define the range.

Re: Button to select values from a list box

Anonymous — Thu, 29 Oct 2015 09:43:01 GMT

Hi,

Maybe try:

1. First create two variables vMinYear and vMaxYear

2. Next create two Input boxes with these variables vMinYear and vMaxYear

3. In the list box properties -> General Tab -> Field -> expression:

=if( Year >= $(vMinYear) and Year <= $(vMaxYear), Year )

Regards,

Neetha

Re: Button to select values from a list box

Thu, 29 Oct 2015 12:04:44 GMT

Thanks for the reply Neetha.

I have exactly done this only.

My problem is that the listbox shows the values falling in this range.

But they are not selected by default.We would need to manually select a/all values.

I need these in between values of the listbox to be selected by click of a button or an enter.

Hope you get my problem.

Re: Button to select values from a list box

settu_periasamy — Thu, 29 Oct 2015 12:09:54 GMT

Hi,

Did you try the swuehl suggestions?

It will select the values instead of showing the range..

Re: Button to select values from a list box

Kushal_Chawda — Thu, 29 Oct 2015 12:27:08 GMT

Create two variable vMin & vMax.

Create a button-> go to properties-> Action -> Select In Field -> Your Field

Search String ='>='&vMin&'<='&vMax

Re: Button to select values from a list box

maxgro — Thu, 29 Oct 2015 12:33:25 GMT

you can use some variables trigger and the swueh's answer

see attachment

Re: Button to select values from a list box

Thu, 29 Oct 2015 13:12:15 GMT

This worked, thanks a lot.