topic Able to non-exact match in search? in App Development

Able to non-exact match in search?

Anonymous — Thu, 06 Apr 2017 14:27:53 GMT

Hi, we are an equity shop with a Investment codes like this:

AUD

AUD Forward Combined

When I start typing AUD, I would like to see BOTH codes. How can I enable this? I have come to find out that Qlik filters only take exact, case-insensitive matches. I'm afraid this won't satisfy our needs.

Thanks.

Re: Able to non-exact match in search?

Gysbert_Wassenaar — Thu, 06 Apr 2017 17:51:20 GMT

I can't reproduce this using QS 3.2:

Can you post an example that demonstrates the problem?

Re: Able to non-exact match in search?

Anonymous — Thu, 06 Apr 2017 20:16:08 GMT

Hello. We are using logic in our field to display it. Something like this:

If(IsNull(Qty) = 0 AND (Qty <> 0.0 OR MktValue <> 0.0),



        if(IsNull(ForwardInvCode) = 0, ForwardInvCode, Investment)



, Null())

We are able to get the Investment Codes display just fine like this and fit our needs.

But when we try to search, we run into the issue described in OP.

Could using formulas and logic be a limitation? As well, we have many thousand distinct Investment codes.

Re: Able to non-exact match in search?

Anonymous — Fri, 07 Apr 2017 15:02:42 GMT

BUMP

Re: Able to non-exact match in search?

Gysbert_Wassenaar — Mon, 10 Apr 2017 08:42:54 GMT

It probably is. Perhaps you can calculate these codes in the script instead.