topic "Or" expression in set analysis no longer working in App Development

"Or" expression in set analysis no longer working

click-er — Wed, 07 Apr 2021 11:45:49 GMT

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.

Re: "Or" expression in set analysis no longer working

marcus_sommer — Wed, 07 Apr 2021 12:07:11 GMT

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

Re: "Or" expression in set analysis no longer working

rwunderlich — Wed, 07 Apr 2021 15:58:01 GMT

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

-Rob

Re: "Or" expression in set analysis no longer working

click-er — Wed, 07 Apr 2021 18:51:51 GMT

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

Re: "Or" expression in set analysis no longer working

rwunderlich — Wed, 07 Apr 2021 18:54:07 GMT

Thanks. I missed that.