Exclude records with 'CLOSED' in text

[#1]

Hi

I need to exclude all account names with 'CLOSED' typed into the account descripion. I cannot find the function to exclude e.g. NOT LIKE equivalent.

Will appreciate a tip or 2.

Regards

[rwunderlich]

Use either:

where not wildmatch(account, '*CLOSED*')

or

account NOT LIKE '*CLOSED*'

-ROb

[#3]

load

[account names]

from tabletest

where not wildmatch([account names], '*CLOSED*')

[Gysbert_Wassenaar]

And if you need a case-sensitive match try where substringcount(account, 'CLOSED')=0

[#5]

Thank you

[#6]

Thank you

On Mon, May 13, 2013 at 3:00 PM, Gysbert Wassenaar <qcwebmaster@qlik.com

[#7]

Hi Rob

I'm trying to select specific suppliers to list in pivot table.

Chart Properties >> Dimensions >> Used Dimensions = Supplier Name >> Enable Conditional Yes >>

Condition =

supplier_addr02 like '*NAMIBIA*'OR

supplier_addr02 like '*WINDHOEK*

Result - does not list any. Do I have to include the "display supplier name" somehow?

I'll appreciate assistance.

[Gysbert_Wassenaar]

The conditional display option for dimensions will show/hide the entire dimension. It does not filter dimension values. You can filter field values in a listbox by clicking on the magnifying glass icon and entering a search string. See the example below which filters Product where the name contains 'pp' or 'an'

For your supplier_addr02 field you can try (*NAMIBIA*|*WINDHOEK*)

[#9]

Let me re-phrase my question.

If I want to sort supplier names based on a specific selection for a pivot table output ....

1. Can I somehow create the selection in the current sheet; or

2. Do I have to sort outside Qlikview and import to work from?

[rwunderlich]

You can create a calculated dimension that will filter values like:

if(wildmatch(supplier_addr02, '*NAMIBIA*', '*WINDHOEK*'), supplier_addr02)

-Rob