topic Re: Possible Where Exists() Optimized load BUG in App Development

Possible Where Exists() Optimized load BUG

gaidamichal — Tue, 21 Apr 2020 16:02:43 GMT

Hello,

I've encountered a strange behavior in Where Exists(). When I use another name for the previously loaded filed I get an unoptimized load but when I rename the other field to match the field name I'm back to optimized. I've attached a sample app for this purpose:

1. Simple Where Exists(Dim1)

Result: Optimized load

2. Changed the filter dim name to Dim5 - Where Exists(Dim5,Dim1)

Result: Unoptimized load

3. Added field Dim1 as Dim5 to the original table, the clause is the same - where Exists(Dim5,Dim1)

Result: Back to optimized load

This feels like a bug in optimized load not being used despite meeting the criteria. Have any of you encountered such behavior? Finding that out saved me a lot of time by simply adding additional field alias.

Re: Possible Where Exists() Optimized load BUG

jsebrightqi — Thu, 12 Oct 2023 16:53:20 GMT

This is still an issue on cloud and windows.

Re: Possible Where Exists() Optimized load BUG

marcus_sommer — Fri, 13 Oct 2023 08:56:26 GMT

I'm not sure if there is really an issue because it could also mean that Qlik knows that both fields are identically respectively there might be just a single field (one field-id with n field-names).

Creating the fields in different steps and/or ensuring that they are not identically by adding/removing any values or applying a different load-order or similar measures may change the behaviour.