Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bouderbc
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
swuehl
Not applicable

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

Maybe

LOAD Title

FROM ....

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

surendraj
Not applicable

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

Load Title from sheet.xls

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

bouderbc
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 ?

swuehl
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?

bouderbc
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