Inconcistency Values between Ajax Access Point and Desktop on some table expressions

Some expressions in QlikView tables return different results in QlikView Desktop and via the Access Point.
This problem is generally related to Section Access: if it is removed, the issue is not present.

Environment:

• QlikView 12 all releases

The problem is due to a known limitation on dynamic data reduction that causes a different management of NULL values in QlikView Desktop and Access Point.
The dynamic data reduction is very similar to making a selection and hiding the non-associated values (permanently for that specific session). This means that a selection (select all possible values) is performed and since null-values cannot be selected, these are in fact left de-selected, thus resulting in a null-return rather than a value.

The most common workaround or practice in this case is to transform the missing values (null) into zero-values instead in the script by using the "nullasvalue" keyword and assign nullvalue=0. This is a fairly simple approach that will work fine in most cases.

Here you can find an article that describes how to use "nullasvalue":

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/NullAsValue.htm