topic Re: Selecting in field via button - check multiple fields for same value in QlikView

Selecting in field via button - check multiple fields for same value

Anonymous — Thu, 20 Feb 2014 15:38:34 GMT

Hello,

I'm trying to create a button that will select all records where the same value, say 'abc' is in either of 2 fields. It could potentially only be in 1 of the 2 fields. So in SQL it would be something like this:

select * from table1

where field1 = 'abc' OR field2 = 'abc'.

Any ideas?

Re: Selecting in field via button - check multiple fields for same value

Anonymous — Thu, 20 Feb 2014 18:00:04 GMT

As I understand, "select records" is not the same in this case as "select values in fields". That is, there should be a record ID that is selected when the condition is met.

See attached. There is field ID, where the selection is made, and fields F1 and F2. To select all records where F1=d or F2=d, enter 'd' in the input box (variable vSelecytion), and click on the text box below it. It has action "Toggle Select". Look at the search string, all logic is there:

='('&concat({<F1={$(vSelection)}>+<F2={$(vSelection)}>} distinct ID, '|')&')'

Re: Selecting in field via button - check multiple fields for same value

Christian_Lauritzen — Thu, 20 Feb 2014 18:10:26 GMT

Once again a nice solution, Michael! Like it!

/Christian

Re: Selecting in field via button - check multiple fields for same value

Thu, 20 Feb 2014 18:11:54 GMT

Hi JO,

Maybe you can try using a Bookmark with your multiple values, then in your button, add an Action "apply bookmark", finally add bookmark ID and taht all.

Best regards.

Re: Selecting in field via button - check multiple fields for same value

Thu, 20 Feb 2014 18:17:30 GMT

Your bookmark will store the wild search. So applying a bookmark is a better option.

Regards

Re: Selecting in field via button - check multiple fields for same value

Anonymous — Fri, 21 Feb 2014 09:18:55 GMT

Thank you Michael, that's exactly what I was looking for and makes perfect sense!

Re: Selecting in field via button - check multiple fields for same value

jazznewbie — Thu, 20 Jul 2017 17:05:10 GMT

Sorry for bumping an old thread. Just wanted to thank for a wonderful solution.

Re: Selecting in field via button - check multiple fields for same value

manideep78 — Fri, 02 Apr 2021 20:50:43 GMT

Hi @Anonymous

This is wonderful and I am working on something like this.

for the same functionality, can I pass same multiple values in input box using delimiter?

search multiple values in multiple fields with OR

also, what if I don't have an ID Field?