topic Re: Search for value in table box with input box in QlikView

Search for value in table box with input box

mattjd — Mon, 13 Mar 2023 00:55:11 GMT

I am very new to QlikView, using the desktop edition V12

I am trying to set up an input box to search a table box for data and if that data is in the table box, a text box will show "x" and if it isnt in the table, it will show "y"

For example, entering 12AB12 in the input box, if the string is in the table, a text box says A and if it isnt, it says B.

Any help would be appreciated, I'm super new to Qlikview and having a hard time with this project.

Re: Search for value in table box with input box

MayilVahanan — Mon, 13 Mar 2023 02:08:43 GMT

Try like below..

=Coalesce( Aggr(If(WildMatch(fieldname1, '*$(vinput)*') , 'A'), fieldname1), Aggr(If(WildMatch(fieldname2, '*$(vinput)*') , 'A'), fieldname2), 'B')

Re: Search for value in table box with input box

mattjd — Thu, 16 Mar 2023 15:04:01 GMT

Sorry for the late reply. For clarification, what would fieldname2 be in this equation, I assume fieldname1 is the field in the table box I want to search in?

For reference, the expression I was using in the text box object was this:

if(match($(inputboxvariable), [tableboxfield]), 'A', 'B')

This expression didn't seem able to actually search inside the table box

Re: Search for value in table box with input box

marcus_sommer — Thu, 16 Mar 2023 16:33:22 GMT

Please elaborate in more details how your scenario look like - what you really mean with table-box, how many fields are included and why an input-box should be used to search for any matching? Some screenshots would be useful.

Re: Search for value in table box with input box

mattjd — Thu, 16 Mar 2023 18:26:15 GMT

I'm trying to create something so a user can type a number in an input box and have a text box show whether or not that value exists in a table.

If I type 5678AB5678 in the input box, the text box would say "A" and if i type 1234AB1234 in the input box, the text box would say "B"

Re: Search for value in table box with input box

MayilVahanan — Mon, 20 Mar 2023 07:11:56 GMT

If you have only one field, you can ignore the field 2

Coalesce( Aggr(If(WildMatch(fieldname1, '*$(vinput)*') , 'A'), fieldname1), 'B')