filter with where clause

[Ayden]

am new to qlik and I am trying to filter my data set with 

where clause.

example 

Load

VOYAGE,

REFERENCE,

JOU_FROM,

JOU_TO,

From XYZ_Table;

so my question they are different countries in JOU_FROM and JOU_TO. how could i Filter data 

JOU_FROM like US* OR Like CA* AND JOU_TO NOT Like US* OR CA* to give all VOYAGES going out of Both countries. And also,

JOU_FROM NOT LIke US* OR CA* AND LIKE US* OR CA* to give all VOYAGES going into both countries.

Thanks i have been trying to get around this any tips would help.

Thanks

Ay.

[Saravanan_Desingh · Accepted solution]

Multiple LIKE commands can be combined like this,

Where WildMatch(JOU_FROM,'US*','CA*') AND Not WildMatch(JOU_TO,'US*','CA*');