Outer Set Expression field ignored when value not present in data set

davwade1 — Fri, 24 Mar 2023 23:40:31 GMT

I am using Qlik Sense EoW Aug 2022 Patch 3. I am getting unusual results when using an Outer Set Expression.

I am applying an Outer Set Expression to a master measure [Filled Positions]. When the value I use for the "Candidate Source" field does NOT exist anywhere in the data set for the app the expression for that field is ignored.

So this measure:

({<[Snapshot Year]={">=$(vPreviousYear_1)"},[Snapshot Month/Year]={"<=$(=Max([Snapshot Month/Year]))"},[Candidate Source]={'_UNKNOWN_'}>}[Filled Positions])

Returns the same value as this measure when "_UNKNOWN_" is NOT present in the data, but works correctly when "_UNKNOWN_" IS present in the data:

({<[Snapshot Year]={">=$(vPreviousYear_1)"},[Snapshot Month/Year]={"<=$(=Max([Snapshot Month/Year]))"}>}[Filled Positions])

If I create a new measure by copying my master measure [Filled Positions] and add the previous Outer Set Expression as an addition to the existing Inner Set Expression the result is correct, regardless of the presence of the "_UNKNOWN_" value in the data set.

Count(distinct{<[Table]={'Days to Fill'},[Max Emp Offer Date Flag]={'Y'},[Snapshot Year]={">=$(vPreviousYear_1)"},[Snapshot Month/Year]={"<=$(=Max([Snapshot Month/Year]))"},[Candidate Source]={'_UNKNOWN_'}>}[Job Req ID])

Is this a bug with my version? I did not read anything in the Qlik Help site related to Outer Set Expressions saying that a field would be ignored if the value was not part of the data set. Because I use Outer Set Expressions often now, it is very disturbing to think that they will work correctly most of the time, but if a value is dropped from the data set entirely, a previously working measure can return erroneous results.

Thanks

topic Outer Set Expression field ignored when value not present in data set in App Development

Outer Set Expression field ignored when value not present in data set