Able to non-exact match in search?

[Anonymous]

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.

[Gysbert_Wassenaar]

I can't reproduce this using QS 3.2:

Can you post an example that demonstrates the problem?

[Anonymous]

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.

[Anonymous]

BUMP

[Gysbert_Wassenaar]

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