Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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