How to apply sql query in qlikview script?
(txt, codepage is 1252, embedded labels, delimiter is '|', msq);
I want to apply:
WHERE country not like A* ?
WHERE postcode <> '1100' AND postcode <> '2200'
How to combine into WHERE postcode <> '1100 2200' ?
Thanks in advance.
You can use Not WildMatch() to do this.
Your code should like below.
(txt, codepage is 1252, embedded labels, delimiter is '|', msq)
Where Not WildMatch(postcode,'1100','2200') and Not WildMatch(country ,'A*');
Hope this helps you.
we Can apply SQL Query in
SQL select statement
Which is used to fetech data from Database
and regarding Where clause
Retrieving data ...