Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I can't reproduce this using QS 3.2:
Can you post an example that demonstrates the problem?
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.
BUMP
It probably is. Perhaps you can calculate these codes in the script instead.