Search for String in script

[Anonymous]

Hi All

I have a filed named 'Type' in QlikView which contains values like Abc, Abcs, Abdr, bef, ltv etc..Now that I need to write in script to return expression values such that where type contains Ab

I tried like where Type=''Ab*' but not returning any values.Please help

[Anonymous]

Now that I want to filter 3 or more fields which have Ab or b or f,how can i achieve this?

[surendraj]

Yes you can...

In where clause

Where wildmatch(Type,'*Ab*','*b*','*f*');

This will filter the values which contain Ab or b or f.