topic Re: Exclude Search Box in QlikView

Exclude Search Box

brettaustin — Fri, 16 Jun 2017 17:03:11 GMT

Hello Qlik Community,

I am trying to create a Search Object that will 'Exclude' the value entered by the user.

1) I was able to 'Exclude' the data using the following in a 'Generic' search object

=Not WildMatch(FieldName, 'SearchValue')

But I am not wanting the user community to enter this string each and every time they want to 'exclude' the values form their result set.

Therefore I tried to...

1) Create a variable

2) Create a user Input Box

3) Create a button to apply the Exclude script above to the search field.

3a) Set an Action (Set in Field)

3b) Macro

Neither approach worked. Any ideas?

Thank you!

Re: Exclude Search Box

vishsaggi — Fri, 16 Jun 2017 17:27:23 GMT

Can you share an example where you want to exclude this. Attached is the file where you can enter any value in the inputbox and it will exclude that value from the Field name Name in the table.

What ever you type in that Exclude inputbox it will exclude that row from the left table.

Find attached a sample qvw.

Re: Exclude Search Box

brettaustin — Fri, 16 Jun 2017 17:51:06 GMT

Thank you! Let me clarify. I want to apply the Exclude Filter to the 'Select in Field' so the filter is applied to the entire dashboard. See attached for example.

Re: Exclude Search Box

antoniotiman — Fri, 16 Jun 2017 18:21:07 GMT

Hi Brett,

see Attachment.

Regards,

Antonio

Re: Exclude Search Box

Anonymous — Thu, 06 Jul 2017 11:59:03 GMT

Try with:

-(SearchValue1|SearchValue2)

Davide

Re: Exclude Search Box

marcus_sommer — Thu, 06 Jul 2017 12:48:05 GMT

Maybe the already inbuilt features will do the job. Just selecting the "unwanted" values and then choosing "exclude values" from the context-menu. I think it's more logical and don't need more (error-prone - because manually typing values) working-steps and is therefore easier to handle for the users.

- Marcus

Re: Exclude Search Box

MarcoWedel — Sat, 08 Jul 2017 00:12:14 GMT

Hi,

maybe one solution could be:

hope this helps

regards

Marco