"Or" expression in set analysis no longer working

[click-er]

Several of our KPIs that have similar a set analysis expressions (using an "OR" condition) returns 0, after a full reload. However, after the app is duplicated, the correct value would appear. 

Here is an example.

count(distinct
{<
emp_action_descr={'Hire','Hire Employee','Contract Contingent Worker'}
,effective={">=$(=$(vCurrentYTDHr))<=$(=$(vCurrentDateH))"}
,emp_action_reason_descr-={'Non Starter Hire','Non-Starter Hire'}
,EOM=,EOMY=
>
+
<
emp_action_descr={'Transfer'}
,effective={">=$(=$(vCurrentYTDHr))<=$(=$(vCurrentDateH))"}
,emp_action_reason_descr={'POI to CWR Conversion'}
,EOM=,EOMY=
>
}
emp_key)

The other curious things is that, when testing out this expression, and running each of the OR segments on their own, there is no problem.  Any insights would be appreciated. 

[marcus_sommer]

If it's don't work directly after a reload but after opening the app it could be related to any section access. Usually the effects of any data-reduction is reversed to your description but if there are any synthetic keys and/or circular loops and/or multiple datamodels and/or partly associated section access it's thinkable.

Therefore I suggest to check the datamodel and if there is any section access and if they work like expected.

- Marcus

[rwunderlich]

I don't see any "OR" condition in your expression?  The set modifiers are effectively "AND" -- is that what you meant?

-Rob

[click-er]

The "Or" condition is the "+" plus sign....as per Qlik recommended expression.

[rwunderlich]

Thanks. I missed that.