Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

crissaegrim
New Contributor III

Able to non-exact match in search?

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.

1.png2.png

4 Replies

Re: Able to non-exact match in search?

I can't reproduce this using QS 3.2:

c256281.png

Can you post an example that demonstrates the problem?


talk is cheap, supply exceeds demand
crissaegrim
New Contributor III

Re: Able to non-exact match in search?

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.

crissaegrim
New Contributor III

Re: Able to non-exact match in search?

BUMP

Re: Able to non-exact match in search?

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


talk is cheap, supply exceeds demand