topic Searching using Wildcards in QlikView

Searching using Wildcards

Tue, 28 May 2013 15:01:55 GMT

Hello,

I currently have a search bar in my dashboard, which is used to search for clients.

The clients are grouped together producing clients grouped. In the clients grouped there are instances where the client is through Lloyd's insurance market (Lloyd's - Star Group) and when the client is not (Star Group). It was built like this so users could get a figure for Lloyd's by just searching Lloyd's, however, the problem occurs when users search for Star Group for example and only Star Group shows up but not Lloyd's - Star Group.

My question is how would I get both clients to show up when searched? Could I do this by using a wildcard (%) in the search bar or do these not exist in QlikView? I have tried using % as the wildcard but with no success.

Many thanks for your time.

John

Re: Searching using Wildcards

Tue, 28 May 2013 15:25:44 GMT

HI,

Instead of using % use *. That is the wildcard for QV. YOu can search '*Star Group' and it will include them both in the dropdown. You will still probably have to select them both when you search though. Hope this helps.

Thanks

Joey

Re: Searching using Wildcards

Tue, 28 May 2013 15:31:22 GMT

you can select USE WILDCARD SEARCH in the properties of your seach bar, so the wildcard caracters will be automaticaly added when your user start to type a name

Re: Searching using Wildcards

Tue, 28 May 2013 15:34:18 GMT

Thats true, it will just automatically add the *'s before and after your seach.