topic Re: Set Analysis Search with wild cards in QlikView

Set Analysis Search with wild cards

kushalthakral — Tue, 09 Aug 2016 15:07:58 GMT

Hi All

i have one requirement for that i need to search string in one field

so for that i need to search that particular word in a set analysis like below

{<[Check] = {"*Machine*"}>}

but it is not working properly, can any one help me on that

Thanks

Kushal Thakral

Re: Set Analysis Search with wild cards

sunny_talwar — Tue, 09 Aug 2016 15:13:09 GMT

I would have assumed it to work, can you try with single quotes instead of double quotes?

{<[Check] = {'*Machine*'}>}

Re: Set Analysis Search with wild cards

kushalthakral — Tue, 09 Aug 2016 15:17:03 GMT

Hi Sunny

i have tried with single quotes but it is not working

i am actually getting blank values for the same

but it is working for Machine* or *Machine but i m getting only values which are starting with Machine or ending with Machine not the values where Machine is in between two words

Regards

Kushal

Re: Set Analysis Search with wild cards

sunny_talwar — Tue, 09 Aug 2016 15:20:57 GMT

How about this:

{<[Check] = {*Machine*'}+{'*Machine*}>}

My bad, I meant this:

{<[Check] = {'Machine*'}+{'*Machine'}>}

Re: Set Analysis Search with wild cards

kushalthakral — Tue, 09 Aug 2016 15:36:52 GMT

Hi Sunny

Actually i have to use in a input box i dont think so it will work there as i have to input multiple values in the input box and then search them

Regards

Kushal

Re: Set Analysis Search with wild cards

sunny_talwar — Tue, 09 Aug 2016 15:52:00 GMT

I guess it might help if you are able to share a sample with your expectation of the output