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
