Nprinting report values not matching with qliksense app

[212040]

I am trying to generate on demand report using nprinting but what I noticed nprinting report values and qlik app values are not matching I tried all options but not able to resolve like checked app id reload metadata object id etc.

[David_Friend]

@212040 what version of NPrinting and what version of QlikSense?

Are you using the NPrinting OnDemand button supplied by Qik (i.e. not a 3rd party one)?

Please (if you can) share some screenshots that illustrate the issue, thanks!

[Lech_Miszkiewicz]

Hi @212040 

Obviously there is not enough information. The reasons that results are different are very simple:

• your report is build using unsupported components
• or your template is not built properly
• or your NPrinting connection points to different app than the one you think you are using
• or is not configured properly in NPrinting (has filters and other unsupported in OnDemand things). 

To diagnose those issues you need to:

• make sure there are no variable inputs (variables) used by users to change your measures
• make sure there are no report filters applied on report in NPrinting which can change results you see
• make sure connection of the report is pointing to the same source you use
• make sure there are no multiple connections in the same NPrinting app as that can confuse onDemand extension used in Qlik Sense to pass selections from UI to NPrinting 
• and many many more.......

Bottom line is - we have no information what your report is, how template is built, if it is built properly etc... There are obviously things @David_Friend mentioned re versions, but those are less important at this stage I would say, nevertheless they are still important if after checking everything else report is still producing different results. 

[212040]

@David_Friend  nprinting version may 2022 sr1 (22.15.5.0)

Qliksense version may 2024 patch 7 (14.187.12)

Yes using qlik supplied button

[212040]

@Lech_Miszkiewicz  yes all the points highlighted are checked then to no luck only value for one column are not matching 

[Lech_Miszkiewicz]

Hi @212040 

so again-what is this one column which has different results?

• Is it measure or dimension?
• If it is calculated then what sort of calculation/formula are you using?
• can you share template screenshot allowing us to understand context?
• maybe you are using level and your formula uses relative function to Total or some sort of aggr-that obviously will work very different

as mentioned before-without knowing details i am unable to help more or pin-point how to fix it. 
cheers

[212040]

@Lech_Miszkiewicz  it's a measure calculated using 

=Text(Num(Count({<PolicyNo=>} B2BID) / ${vTotalOutcomes}, '0%'))

vTotalOutcomes = Count({<PolicyNo=, Outcome=>} DISTINCT B2BID)

[Lech_Miszkiewicz]

Hi @212040 

Ok, We are getting closer.

As I suspected you are trying to use measure relative to total since you are deviding numerator by variable which is coming from expanded variable!!!

So now if you look at my previous answer I also asked about screenshot of the NPrinting template. Can you share that now?

Depending how it is built measures like yours can be very much affected. If it uses Levels or Pages or Cycles in your report the total will be affected same way as if you would apply selection on each value of field used in such object in NPrinting.

side notes:

• I am assuming that this is what the measure is like
  • =Text(Num(Count({<PolicyNo=>} B2BID) / $(vTotalOutcomes), '0%')) and not this:
  • =Text(Num(Count({<PolicyNo=>} B2BID) / ${vTotalOutcomes}, '0%'))
• I am also assuming that your variable vTotalOutcomes starts with "=" sign in variable editor hence it just returns measure value based on current selection and disregarding object granularity! 
• It is strange measure as you are trying to do count(ID)/Total(Count DISTINCT ID). 

[212040]

@Lech_Miszkiewicz  please find ss of template also 

[Lech_Miszkiewicz]

Hi @212040 

Just to make sure we are not affected in this case by not expanded variables I would suggest you use below expression as your measure:

Text(Num(Count({<PolicyNo=>} B2BID) / $(=Count({<PolicyNo=, Outcome=>} DISTINCT B2BID)), '0%'))

If that does not work you may need to read all below and  spend some time making sure you provide all the required info before we try to move forward.

https://community.qlik.com/t5/Qlik-NPrinting/Chart-Legend-containing-Date-has-different-value-when-o...

this link is not an answer to your question but it will help you understand how you should ask question on community to get help quickly and what kind of details we need to be able to replicate your issue. Have a look at how I have posted my issue and how I guided others to help me resolve it. If you really need us to help you solve this problem you may want to put little bit of effort to describe the issue as much as possible without us trying to guess what is what.

As to what your screenshot shows is powerpoint with 3 objects. We dont know where that object causing troubles is, we dont know If you applied any object filters to it as we dont see Properties of that object. 

Also - you posted in other of your replies actual versions of Qlik Sense and NPrinting. One important thing about the version of NPrinting should be usually newer than Qlik Sense as otherwise it is not really supported as @David_Friend mentioned earlier. In this case you are actually on rather very old version which is not compatible with your Qlik Sense as documented: https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DeployingQVNprinting/System-requirem...

Lastly - if you have used Master Measures you may also be affected by this issue: 

https://community.qlik.com/t5/Qlik-NPrinting/Gauge-from-Qlik-sense-into-Nprinting/td-p/1839212 although at this stage it is hard to judge becasue we dont know what kind of issues we have and as to why it would not work.

cheers