topic How to do a "lookup" based on InputField value? in QlikView

How to do a "lookup" based on InputField value?

Mon, 18 Jan 2010 21:04:05 GMT

II need QV to go do a "lookup" based on the value the user enters into an InputField to extract a corresponding value from another table. How do I go do a "lookup" based on the user input into an InputField?

How to do a "lookup" based on InputField value?

prieper — Mon, 18 Jan 2010 22:09:02 GMT

Have you had a look into the LOOKUP-function available in QV?

HTH
Peter

How to do a "lookup" based on InputField value?

Mon, 18 Jan 2010 22:16:02 GMT

Yes, the lookup function is only an interrecord function that can be used during the load script. I need the "lookup" to happen after the user changes the InputField value, and I need to lookup to occur based on the new value the user has entered into the InputField.

How to do a "lookup" based on InputField value?

prieper — Mon, 18 Jan 2010 22:43:22 GMT

You are right - have never worked with it. On the fly there is a quick combination possible of FieldValue and FieldIndex - see the example, which may help a bit

Peter

How to do a "lookup" based on InputField value?

johnw — Mon, 18 Jan 2010 22:50:40 GMT

Another approach:

=only({1<Item={'$(=sLook4)'}>} Val)

How to do a "lookup" based on InputField value?

Mon, 18 Jan 2010 23:51:12 GMT

Very interesting, I think this will work, I should have thought of this - arg! I'll give this a shot and get right back with ya... THANKS!

How to do a "lookup" based on InputField value?

Tue, 06 Mar 2012 03:35:04 GMT

Hi,

hope my problem's solution lies here....

i have a column having values 20,30,40.....100

want to have user input a value in input box, say 25.....then the column shud show only the data where column>25

Regards

Re: How to do a "lookup" based on InputField value?

Wed, 22 Oct 2014 13:50:55 GMT

qlik techie, how did you solve your problem? I have the same

Re: How to do a "lookup" based on InputField value?

Andrea_Ghirardello — Wed, 22 Oct 2014 14:07:08 GMT

Do you mean something like the attached example?

Write ">1250" or "<1400" in the condition and the chart will show only data that fulfil the condition.

Obviously, if the operator is known and you want to input only the value, you can "move" the operator from the condition into the expression.

Hope this helps.

Re: How to do a "lookup" based on InputField value?

Fri, 24 Oct 2014 18:56:55 GMT

In my case It should be more like a vlookup function, but from the declaration of the input from somebody

In my case I am looking for some value depending on the range of a sum insured.

i.e.

Table A

Sum Insured from Sum Insured to Factor

10,000 19,999 .1

20,000 29,999 .7

30,000 39,999 .8

40,000 100,000 .9

"If the client inputs $34,000", the value to use will be .8

regards

Re: How to do a "lookup" based on InputField value?

Andrea_Ghirardello — Mon, 27 Oct 2014 07:52:20 GMT

you should try using the IntervalMatch function.