Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
davwade1
Contributor III
Contributor III

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

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

Labels (1)
0 Replies