what is the equivalent of "not like" in the qv script?
WildMatch() helps in dealing situations like this. If it returns 0 then it means that there is no match, it is similar to no like SQL.
WildMatch(FieldName, value1, value2) = 0
Wild match is the only replacement for like in qlikview with some extended.
You can use like this
Where not WildMatch(FieldName,'value*','value2*');
thanks everybody...i used not wildmatch(field, '*abc*')
Retrieving data ...