# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Not applicable

## Text filter data in the load script ? (where text contains...) Help!!!!

Text filter data  in the load script  ? (where text contains...)

usually  i use where but in my case it doesn't work properly because i have different types of character string ( Alpha numeric character, text character ) and they aren't always the same , please see the example below and File Attached :

When i want to filter on security with where , he did the job but he loads also other parts of the file , so is not efficient

please if u know this case , give me your solutions !

Name of the column: Title

Needs: Filter only where the field contains 'security'

Tags (1)
5 Replies
Not applicable

## Re: Text filter data in the load script ? (where text contains...) Help!!!!

Maybe

FROM ....

WHERE Wildmatch(Title,'*Security*');

Not applicable

## Re: Text filter data in the load script ? (where text contains...) Help!!!!

where wildmatch(title,'* security*');

Not applicable

## Re: Text filter data in the load script ? (where text contains...) Help!!!!

Hi Stephan,

Thanx for your answer , i have already use it , it doesn't work properly , so i use a flag as a filter  :

if(WildMatch(Title,'*Security*'),'True','False') as Flag ,

i can filter now on my Data ,  but Now i want to use this flag in the load script, is it possible ?

Not applicable

## Re: Text filter data in the load script ? (where text contains...) Help!!!!

Can you upload a sample QVW with some sample data that demonstrates where the WHERE clause does not work properly?

Not applicable

## Re: Text filter data in the load script ? (where text contains...) Help!!!!

Stephan , sorry  i can't share my Data , but i put an excel sample.

Thanx a lot

Community Browser