Where Statement

Wed, 13 Aug 2014 14:32:56 GMT

If i wanted to add in a where statement to show any customer containing a certain word or words how would i write that? i want to only show 1 customer out of lets say 20 customers but that one customer has 10 different stores, so how could i say i want to see everything containing that main name of that customer?

Ex. CUSTOMER (just want to show everything that includes this word so it would include both of the below)

- CUSTOMER123

-CUSTOMER456

thanks for the help!

Re: Where Statement

MK_QSL — Wed, 13 Aug 2014 14:34:39 GMT

Load Customer, * from TableName

Where Wildmatch(Customer,'*SearchField*');

topic Where Statement in QlikView

Where Statement

Re: Where Statement