topic Re: Search String for multiple Fields in QlikView

Search String for multiple Fields

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a slider that assigns the value to a variable vEndNetwr. If vEndNetwr changes, i want to select in two Fields, but with an OR Operator. Means when I change the slider, it should return me records where field 1 is larger than vEndNetwr OR field 2 is greater than vEndNetwr.

So far ive done it for one field, where I define an action "Select in Field" with Field 1 and a search string "='>=' & vEndNetwr ".

For one field it is pretty easy, but how do I do this for 2 fields with OR Operator?

Thanks!

Re: Search String for multiple Fields

ahaahaaha — Wed, 02 Aug 2017 14:18:20 GMT

Hi,

May be like as at attached file?

Regards,

Andrey

Re: Search String for multiple Fields

Thu, 03 Aug 2017 08:27:43 GMT

Hi Andrey,

Thank you for your reply.

For example you have a table called Table 1:

ID value1 value2

1 10 40

2 25 10

3 30 30

4 5 15

I have a slider which shows value from 0 to 100. If i change the slider to value = 20 it should return me all

rows where value1 is greater than 20 OR value2 is greater than 20. How can i do this?

ID value1 value2

1 10 40

2 25 10

3 30 30

Thanks!

Re: Search String for multiple Fields

sasiparupudi1 — Thu, 03 Aug 2017 17:42:33 GMT

May be like attached?

Re: Search String for multiple Fields

Fri, 04 Aug 2017 10:43:31 GMT

Hi,

can you tell me what actions and variables I need, since I unfortunately work on a desktop version without a license.

Thank You