Filtering dbase (sort)

[#1]

I have 3 fields and i want to filter out with a key word how do i do it?

See example:

S/N	Comp	Amount
1	Afrihob Shop	200
2	Mavrikshop	400
3	Deco Shores	300
4	SirV Sp	230
5	Genesis	100
6	Marikosshop	201
7	Merit SHop	40

I want to filter my database using "Where" to pick only the Comp having Shop, SHop or Sp

[marcus_sommer · Accepted solution]

In qlikview you could use: where wildmatch(Comp, '*Shop*', '*SHop*', '*Sp*') and per sql something like: where Comp like '*Shop*' or Comp like '*SHop*' or Comp like '*Sp*'.

- Marcus

[#3]

Operator "LIKE" in QlikView?