This challenge is the difference is coming from 2 separate QV applications.
Difference = B_1_0 - A_1_0
May be I need to use your suggestion to form an intermediate workbook then reference that workbook in another QV Application to pull the required data. This process seems to be the long way.
I did not find anywhere where NPrinting can directly pull a workbook without QV application.
You can use more than one Connection (each to different QlikView applications) in a report so if you are considering option 2., no intermediate Excel file is necessary.
NPrinting only uses QlikView (and Qlik Sense in versions >= 17.1) as sources (called Connections) for reports.
HTH - Daniel.
I did your suggestion in the above note. This works for Excel Report but the challenge is how can I use the 2 connections in NPrinting HTML to display the difference. My thoughts were to develop a calculation using a formula. I try that but the syntax is different and did not resolve into a result.
What do you think?