Help with getting the range values of the Input boxes

[#1]

Hi All,

I need some help with the solution for following Scenario.

I have a huge list of account numbers.

I want the users the flexibility of entering the beginning range and ending range in the input boxes and when they click on 'GetAccounts' button they should be able to see all the account numbers within the range.

Here is the visual explanation of what i am trying to achieve..

Beginning Range
1001

Ending Range
1050

Get Accounts
Get Accounts ----> BUTTON

when the user clicks on 'Get Accounts' button we should display values from 1001-1050 only...

Please  give your suggestion and process as to how to achieve this step by step.

Thanks for looking into this.

[Anonymous]

Input boxes mean variables.  Let say you have variables vBeginning and vEnd.  So, you need a button or a text box with action "Select in Field", the field name is "Account Number", and the search string of this action will be:

='>=' & vBeginning & '<=' & vEnd

[maxgro]

3 variables vstart vend vsearch in an input box

vsearch           ='>=$(vstart)<=$(vend)'

1 button with action

select in field

field                  account

search string     =vsearch

[#4]

Thanks Michael.

I will try as you suggested.

[#5]

Thanks Massimo..

[Anonymous]

But the best way - no input boxes, no variables, no buttons.  Just click on the caption of the Account list box, and type >=1001<=1050

, and press Enter

[#7]

Hi Massimo,

I tried this but it is not working..

do you think i am missing something.?. I am new to qlikview..so don't mind me if i am doing something wrong with the easy stuff also.

Thanks

[maxgro]

did you try the a2.qvw?

[#9]

I cannot open the qvw attachment..as i have the personal edition and it is not recomemended to open these files.

Is it the same that i  see as a picture in the body of the thread..?

Thanks again..

[#10]

.. That should be the simple solution.. but what if we want to 'send it to excel' OR what if we we want to show more than one field in the layout..will that work..?

Thanks