Expression in NPrinting shows different results than in QlikView

[gavinlaird]

We have an object in QlikView that we are using in NPrinting with no filters applied at any level. In QlikView, the expression below returns 7, but the excel report generated from NPrinting returns 4. Does NPrinting calculate expressions with Set Analysis differently than QlikView? What could be causing this expression to produce different numbers in these two tools?

=count({<Type={'Consumer Loan'},FundedThisYear={'1'}>
+<Type={'Consumer Loan'},SubmittedThisYear={'1'},Funded={'Funded'}>} AppID)

We did run the cache-generation task for the NPrinting connection to the qvw this object is from, to make sure it is using recent data.

[gavinlaird]

I forgot to put this in the post: I added AppID as a dimension (which is the field being counted in the expression) to see which ones were not being counted. The applications excluded from this expression when calculated in NPrinting (but are not excluded in QlikView) are the ones where FundedThisYear=1 and SubmittedThisYear=0. 

[Lech_Miszkiewicz]

NPrinting calculates expressions the same as QlikView.

Difference in results may come from:

• use of section access
• use of task/reports or recipient filters

[Ruggero_Piccoli]

Hi,

Qlik NPrinting itself doesn't calculate expressions. It sends expressions to QlikView or Qlik Sense, they calculate, and Qlik NPrinting adds the results to the generated reports. 

In your case the expressions are calculated on QlikView, the object exported and that data are used by Qlik NPrinting in the reports. 

About Section Access refer to https://help.qlik.com/en-US/nprinting/September2019/Content/NPrinting/DeployingQVNprinting/Section-a.... I think there is something in the user configuration or in the filters.

Best Regards,

Ruggero

[gavinlaird]

Thanks for the response Ruggero!

We have no filters in NPrinting at any level (report, task, recipient), and we don't use section access, which leaves the last option "something in the user configuration". Do you know what we might be looking for in the user configuration that could cause some records to be excluded?

[Ruggero_Piccoli]

Hi,

Be sure that you had met all the user requirements https://help.qlik.com/en-US/nprinting/September2019/Content/NPrinting/DeployingQVNprinting/Section-a...

Best Regards,

Ruggero