Discussion board where members can get started with QlikView.
Kindly Give example to explain your problem.
To exclude values
Where Match(field, 'ValuetoExclude') = 0
Where Not(Match(field, 'ValuetoExclude')) // if that is more readable
if you have only 3 values than use the where clause
where A='value1' or A='value2' or A='value3' ;
or if you have multiple fields than
where A='value1' and B='value2' and C='value3'
Always use Mixmatch() so even if there is any upper/lower casing differences then also it works.
Note: Qlikview is case sensitive. A and a is not the same in Qlikview.
Where Not MixMatch(Customer, 'A','B','C');
Hope this helps you.