Excluding a value from a dynamic value list within a variable Input

[YaRennik]

Hi Qlik Community,

I've been working on a this for a while and can't figure out a solution, so any help is greatly appreciated:

I am using a Variable Input box. I am using the drop down option.

To fill in the drop down I am using the dynamic value option.

My goal is to list all company names:

ABCD GmbH

ABCD AG

However I want to exclude all that Include AG.

Is that possible?

I tried using Wildmatch, but couldn't figure out how to use that correctly for this usecase.

Your help is greatly appreciated! 

[Or · Accepted solution]

=Concat(distinct if(NOT Wildmatch(Company,'*AG*'),Company),'|')

Sorry if the syntax is a bit off, I can't test it at the moment.

[YaRennik]

That works, thank you for you quick reply! 

[YaRennik]

Hello again,

in order to properly filter the data I need to add an ' before and after every word. 

I tried:
=Concat(distinct if(NOT Wildmatch(''' & [Company] & ''','*AG*'),[RP name]),'|') 

However this puts out an error. Shouldn't it be possible to have a quotation mark inbetween to quotation marks? 

Your help is greatly appreciated

[Or · Accepted solution]

Chr(39) should do the trick.

[YaRennik]

Thank you so much! That works