Qlik NPrinting Image Report Issue: Measure Not Reflecting in Image Output (Qlik Sense Object Displays Correctly)

[Hrudaynath]

We are using Multiple measures in the Qlik sense Object and when I try to generate Nprinting report in IMAGE Format with some filters to it via ON DEMAND Button, one measure is completely showing 0's whereas other measures reflecting the correct data. I tried making it as a table and even tried adding that Single measure in image, table (Cell) still it is showing 0's. 
What would be the reason and is there any Solution?

[Ruggero_Piccoli]

Hi,

It seems there are applied filters but we need more detail to understand your scenario.

Which kind of Qlik NPrinting reports are you generating? If that type supports object filters did you checked if there are some applied to the object with the issue? Has that object some configurations in Qlik Sense like set analysis or in Qlik Sense with the same filters as Qlik NPrinting displays the correct data?

Best Regards,

Ruggero

[Lech_Miszkiewicz]

HI @Hrudaynath 

Since you are mentioning that this is not working with OnDemand maybe you are setting some variables via user interface in Qlik Sense which will not work with OnDemand as variable inputs are not supported. 

Hard to understand more without actual content and example from you. 

cheers

[Hrudaynath]

Hi @Ruggero_Piccoli , @Lech_Miszkiewicz 

It's a PPT and the object is in the Image format and that object has multiple measures with filter attached to the object (in Nprinting) and some other selections in Qlik sense app before generating the report from ON Demand Button. Here the other measures with same filters generating the output except that one measure.
For an example - I'm able to generate the data for '$(vmaxyear)' (Measure 1) in both Qlik sense and Nprinting report which was generated but for '$(vminyear)' (Measure 2) I'm able to see the data in Qlik sense but getting 0's in Report as they are from same object one is accepting all those filters and reflecting same in the sheet where the object is in image format in PPT Report but why not the other measure?

[Lech_Miszkiewicz]

As we said earlier. There are likely:

• contradicting filters already in the report vs on demand selection
• Or there are variables in use which are not supported in OnDemand

to explain what happens we would need to know:

• expressions used for your measures including definitions of variables likely used in them
• selection filters you are applying when trying to generate report
• see if there are any object/report/user Nprinting filters created/applied to report

bottom line is: it is not Nprinting which is not working, it is issue with the way your app, objects and nprinting report is build. 

[Ruggero_Piccoli]

Hi,

You could try to temporary add a =getcurrentselections() formula in the template. Run a On-Demand request and check if the filters showed by the formula are not compatible with the object filter applied to the image. 

Best Regards,

Ruggero

[Hrudaynath]

IF($(eSE_Rank_Scalar_Denominator($(vCurrent_Year),Metric;Name))>0,
dual($(eCount_KEY($(vSelected_Client);$(vCurrent_Year)))
,1.5))

 -  This expression used for '$(vmaxyear)' which is reflecting data in both Qlik sense and Nprinting

IF($(eSE_Rank_Scalar_Denominator($(vCurrent_Year),Metric;Name))>0,
dual($(eCount_KEY($(vSelected_Client);$(vPrevious_Year)))
,1.5))

- This expression for '$(vminyear)' which is not reflecting data in Nprinting

Where I have added vCurrent_Year & vPrevious_Year in Nprinting Variables still unable to get data for '$(vminyear)' still unable to get even after adding

Any Clues and Suggestion please

[Lech_Miszkiewicz]

Hi @Hrudaynath 

That is obviously not enough infomration as you just presented us with variables which can have anything in it. We need details, so...

what are the definitions of:

• eSE_Rank_Scalar_Denominator
• vCurrent_Year
• eCount_KEY
• vSelected_Client
• vPrevious_Year

If there are another variables used inside of those variables we also need to see what those definitions are. 

It does not make sense guessing all this if all your expressions are encapsulated in variables which we dont know and we dont know how they are controlled. 

Lastly, Are there any hidden selections you dont see? Can you make screenshot of your current selection bar when you clear all your selections and paste it here?

Thanks

[Ruggero_Piccoli]

Hi,

Qlik NPrinting receives data exported from Qlik Sense. If the data in the report is different than the one in Qlik Sense it means that there are different filters. In other words, if you apply exactly the same filters in Qlik Sense and in Qlik NPrinting you will see in both the same values because Qlik NPrinting doesn't contains any data, it asks for them to Qlik Sense. 

You could add the getcurrentselections() formula into the template and check the result. You can remove any filters when you generate the report to see if it still has filters and do similar investigations. 

I agree with @Lech_Miszkiewicz about missing details.

Best Regards,

Ruggero