Skip to main content

App Development

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
crissaegrim
Contributor III
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
Gysbert_Wassenaar

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

BUMP

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand