Nprinting is not evaluating the chart expression like Qliksense

[leni_harishwara]

Hi All,

In Nprinting, I am using one of the chart as image and there is no filters applied in the Nprinting level. But the generated report is having the bar chart different from the actual bar chart.

In the actual bar chart, the date selection is ignored using set analysis whereas the generated chart via Nprinting considers the date selection in turn we found mismatch between Dashboard chart and Nprinting report.

Set Analysis used as below in chart,

Count({<Date=>}distinct Product)

Nprinting Version used : Qlik NPrinting February 2025 SR4 - Version: 25.5.17.0

Regards,

Leni Balakrishnan

[Navaneeth]

Please share more details. Usually pasting the image takes a snapshot to nPrinting of what it is available during the generation of a report.

[rubenmarin]

Hi, I would check the connection used by the report, and the configuration of that connection to confirm the app id, and check the data on the app with that id you can update the metadata to confirm it has all the last modifications.

If that's ok, I would check the report filters and the object filters, if it's confirmed that there are no filters, I would try to generate again from the template, confirming that he id of the object is the same as the id object on the app. At that point the data should be the same on the report and in the app.

If they are the same, and the task generates a report eith different data, then there could be a filter in the user or task.

[leni_harishwara]

Hi,

As mentioned, I have checked all points and all are same as expected.

But what I observed is that, the 'select excluded' values are missing from the Nprinting chart.

In my scenario, the selection on date is excluding few values from modality field and the chart in dashboard has set analysis where it ignores the selection on date so it is showing values for all modalities but in Nprinting the excluded values are not showing up.

I am using on-demand button to generate report and it seems like there is a limitation,

Now I would like to know is there any workaround to handle this scenario.

Regards,

Leni Balakrishnan

[rubenmarin]

Hi, I think I haven't found that exact situation, it's a big coincidence that I've never used a set analysis that excludes filtered values in an on-demand report but it could have happened.

I can only think in edit the model to create the summarized data avalaible as the report will need, like loading a table using a key field with the needed selections (product, modality...), leaving outside the key the Date field. It could be complicated and even not possible it there a lot of data or a complex model.

Maybe @Lech_Miszkiewicz has a better workaround.

[Lech_Miszkiewicz]

Hi, 

i am on leave with poor internet connection and replying from my phone. Long story short you need to workaround the requirement which states clearly what happens with data model when selections are applied. 
Obviously in this scenario you may need to  think of creating different data model solution to handle this requirement and your setup. Typically it would be island table for selections and set analysis expressions referencing those island table selections. 
since it is island table it will not reduce factual data as it currently happens. 
if your current solution requires part of data model association to still work this may need to be also recreated as part of the parallel island table selection mini data model. 
i recognise this is not easy challenge but still it is possible to do.
cheers