topic Re: Search for String in script in QlikView

Search for String in script

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Search for String in script

adamdavi3s — Fri, 03 Feb 2017 07:27:03 GMT

Hi use the wildmatch function to help you out:

if(wildmatch(Type,'AB*'),value,0)

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

This will help users identify the answers should they come across this thread in the future.

Re: Search for String in script

Anonymous — Fri, 03 Feb 2017 07:29:41 GMT

can I have something like using where clause so that I can restrict values from script itself

Re: Search for String in script

surendraj — Fri, 03 Feb 2017 07:31:56 GMT

Try with

LOAD * INLINE [

Type

Abc

Abcs

Abdr

bef

ltv

]Where wildmatch(Type,'*Ab*');

Re: Search for String in script

adamdavi3s — Fri, 03 Feb 2017 07:32:06 GMT

You can use wildmatch in the script as well which is essentially a WHERE LIKE clause

Re: Search for String in script

Chanty4u — Fri, 03 Feb 2017 07:33:16 GMT

u can try wildmatch here

wildmatch( M, 'Ab*','Ab?','ab')

Re: Search for String in script

Chanty4u — Fri, 03 Feb 2017 07:35:20 GMT

Let vCheck='Ab*';

for text object:

=if(FieldIndex('Field',vCheck)>0, True(),False())

Re: Search for String in script

adamdavi3s — Fri, 03 Feb 2017 07:37:06 GMT

Why would you do this when wildmatch will return a true / false anyway and not require an if statement?

Re: Search for String in script

Anonymous — Fri, 03 Feb 2017 07:37:16 GMT

Thank you very much it helped

Re: Search for String in script

Chanty4u — Fri, 03 Feb 2017 07:38:56 GMT

yes but if he can check in front end also he can get to know .

Re: Search for String in script

Anonymous — Sat, 04 Feb 2017 11:47:18 GMT

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

Re: Search for String in script

surendraj — Sat, 04 Feb 2017 15:38:29 GMT

Yes you can...

In where clause

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

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