topic Re: Help with getting the range values of the Input boxes in QlikView

Help with getting the range values of the Input boxes

Tue, 07 Apr 2015 18:47:37 GMT

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.

Re: Help with getting the range values of the Input boxes

Anonymous — Tue, 07 Apr 2015 19:08:35 GMT

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

Re: Help with getting the range values of the Input boxes

maxgro — Tue, 07 Apr 2015 19:26:50 GMT

3 variables vstart vend vsearch in an input box

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

1 button with action

select in field

field account

search string =vsearch

Re: Help with getting the range values of the Input boxes

Tue, 07 Apr 2015 19:28:48 GMT

Thanks Michael.

I will try as you suggested.

Re: Help with getting the range values of the Input boxes

Tue, 07 Apr 2015 19:30:02 GMT

Thanks Massimo..

Re: Help with getting the range values of the Input boxes

Anonymous — Tue, 07 Apr 2015 19:42:47 GMT

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

Re: Help with getting the range values of the Input boxes

Tue, 07 Apr 2015 22:11:14 GMT

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

Re: Help with getting the range values of the Input boxes

maxgro — Tue, 07 Apr 2015 22:20:42 GMT

did you try the a2.qvw?

Re: Help with getting the range values of the Input boxes

Tue, 07 Apr 2015 22:39:20 GMT

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..

Re: Help with getting the range values of the Input boxes

Tue, 07 Apr 2015 23:00:06 GMT

.. 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

Re: Help with getting the range values of the Input boxes

Anonymous — Tue, 07 Apr 2015 23:34:20 GMT

Well, no matter how you do it, with input boxes or without, using my suggestion or the one from maxgro‌ (more or less the same) - export to excel will be working the same way. As for the "more than one filed in layout" - it can be used in a table box and in a table if option "Drop-down select" is allowed. Of course you cannot use the above method if you don't show this field on the front end, which is often the case, typically with dates.

So, if possible - keep it simple. Complications will find their way to you when you don't look for them

Re: Help with getting the range values of the Input boxes

maxgro — Wed, 08 Apr 2015 07:13:29 GMT

yes, the same and it works

Re: Help with getting the range values of the Input boxes

Wed, 15 Apr 2015 16:23:13 GMT

Hi Massimo,

Here is the snip what i get when i cclick on the button'Geta/c'.

I don't see the list of correct values, instead it displays everything in 'Green'.

I must be doing something wrong.

Please let me know your inputs.

Thanks

Re: Help with getting the range values of the Input boxes

maxgro — Wed, 15 Apr 2015 16:29:12 GMT

button

variable

script

load rowno() + 1000 as account

autogenerate 100;

Re: Help with getting the range values of the Input boxes

Wed, 15 Apr 2015 17:02:37 GMT

Hi Massimo,

Here is the snap i forgot to attach en the earlier post..

Sorry for that..

Appreciate all the help..

Thanks

Re: Help with getting the range values of the Input boxes

maxgro — Wed, 15 Apr 2015 17:51:31 GMT

what's your VarSearch?

it should be

='>=$(VarStartAccount....)<=$(VarEndingAccont....)'

Re: Help with getting the range values of the Input boxes

Wed, 15 Apr 2015 18:17:01 GMT

Hi Massimo,

Here is the varible as per variable overview..

='>=$(varStartAccountNumberRange)<=$(varEndingAccountNumber)' .

I am Aattaching the snip here for the clarity.

Thanks

Re: Help with getting the range values of the Input boxes

maxgro — Wed, 15 Apr 2015 20:59:35 GMT

your vars are in different case,

sometimes

varP

sometimes

VarP