Inconsistent Values between Access Point and Desktop on some tables in Expression Calculation

[Sonja_Bauernfeind]

Some expressions return different results in QlikView Desktop and Access Point. The problem is generally related to Section Access as when this is removed the issue is not present.

Environment

• QlikView 

This is caused by a known limitation in how NULL values are managed between the AccessPoint (QlikView Server) and QlikView Desktop. 

Resolution:

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 is an article that describes how to use "nullasvalue": NullAsValue (Help.Qlik.Com)

Internal Investigation ID(s):

QVII-1043