topic Re: Data not displaying in Nprinting reports in Qlik NPrinting

Data not displaying in Nprinting reports

manojkumar — Sat, 16 Nov 2024 00:35:58 GMT

Chart data is not displaying in excel or html reports. Connection is created and reloaded and not filters applied. I am using Nprinting February 2020 and qliview desktop November2017 SR3. Please help me to resolve this issue.Below are the screenshots attached.

PREVIEW_EXCELTEMPLATE_EXCEL

Re: Data not displaying in Nprinting reports

Lech_Miszkiewicz — Fri, 29 May 2020 06:37:42 GMT

I don't know what do you expect to see - but it is showing exactly what is in QlikView when you do Clear All!

I am assuming the chart you are trying to use is using conditional expressions (which is not a great idea with NPrinting) and those expressions are being all disabled.

This is working as designed

Read help.qlik.com on what are supported qvw files. Always 1 selected values, alternate states, triggers, some conditional hide/show, web view are not supported!

hope this helps!

Re: Data not displaying in Nprinting reports

manojkumar — Fri, 05 Jun 2020 13:10:55 GMT

Hi Lech_Miszkiewicz ,

Thanks for the info.I didn't use conditional expressions in charts. The attachments which I tagged to this reply consists of table box and a chart.

Still the data is not displayed in html report. Please guide me to resolve it.

Re: Data not displaying in Nprinting reports

Lech_Miszkiewicz — Sat, 06 Jun 2020 01:08:18 GMT

Hi,

I can't tell anything from screenshots... couple more questions

Have you got any filters created?
Are there any recipient filters applied?
What kind of QlikView connection are you using (Local or QVP?)
If QVP is your QlikView desktop version installed on Engine node exact same version and SR as your QlikView server version?
Can you create task, run it, see task execution page for more info or inspect logs?

thanks

Lech

Re: Data not displaying in Nprinting reports

manojkumar — Mon, 08 Jun 2020 14:39:13 GMT

While previewing the html itself Iam not able to see data.

Below are the details for the questions asked

1)No filters applied
2)Published task to all reciepients.
3)Iam using local qlikview connection.
4)QlikView desktop version -- november 2017 SR3
nprinting server and engine version -- febrauary 2020
5)Yes able to see task execution and inspect logs

Re: Data not displaying in Nprinting reports

Lech_Miszkiewicz — Mon, 08 Jun 2020 23:39:19 GMT

hi,

I would expect you would evaluate what is in logs? Are there any errors or warnings, anything?

Since you are using LOCAL QlikView connection, did you reload metadata after each qvw reload?

This qvw app seems also simple and looks like dummy - would you be able to attach it here? Also would you be able to export your report template from NPrinting and attach here so I can recreate it in my environment?

I have never come across issue like this before so I blame it on human error. Hence I want to check your files and setup.

thanks

Lech

Re: Data not displaying in Nprinting reports

manojkumar — Tue, 09 Jun 2020 12:19:58 GMT

Hi,

I attached the qvw file please take a look .

Thanks,

Manoj

Re: Data not displaying in Nprinting reports

Lech_Miszkiewicz — Tue, 09 Jun 2020 12:32:57 GMT

Hi. What about nprinting report template? Can you export it and attach it as well?

Re: Data not displaying in Nprinting reports

Ruggero_Piccoli — Tue, 09 Jun 2020 12:43:51 GMT

Hi,

Your QVW works in my installation. Please check your Qlik NPrinting installation. Does this problem happen only with this document? What happen if you add the same object in the Tables node?

Be sure also that the Windows user that runs the Qlik NPrinting Engine service has a valid QlikView Desktop license. The Personal Edition is not supported.

Best Regards,

Ruggero

Re: Data not displaying in Nprinting reports

Lech_Miszkiewicz — Tue, 09 Jun 2020 21:42:42 GMT

Hi @manojkumar

The same as @Ruggero_Piccoli said. It is working. Nothing we can do here with the info we have.

All I can suggest is to make sure you meet all requirements from help.qlik.com for your environment and accounts.

thanks

Lech

Re: Data not displaying in Nprinting reports

manojkumar — Wed, 10 Jun 2020 12:55:36 GMT

Hi,

Does the leased license from qlikview server for local qliview desktop works?

Re: Data not displaying in Nprinting reports

Lech_Miszkiewicz — Wed, 10 Jun 2020 13:08:19 GMT

It does - details as always in help document:

https://help.qlik.com/en-US/nprinting/April2020/Content/NPrinting/DeployingQVNprinting/Licensing-Qlik-NPrinting.htm#anchor-1

Re: Data not displaying in Nprinting reports

Ruggero_Piccoli — Wed, 10 Jun 2020 13:18:37 GMT

Hi,

No, you must use a Named CAL or a license code. Leased licenses could be moved by the server to another users so when Qlik NPrinting Engine opens the qv.exe process to generate the reports, QlikView will be in Personal Edition and this will not work.

So you can use a leased license, but sometimes it could not work.

Best Regards,

Ruggero

Re: Data not displaying in Nprinting reports

manojkumar — Wed, 10 Jun 2020 13:30:05 GMT

Hi,

Thanks for the info.Till now Iam using leased license . Now I am connecting directly to qlikview server through qvp protocol.Issue Iam facing is with incompatibility of qlikview server and qlikview desktop. I attached the screenshot below.

Can you please suggest which version of qlik desktop is compatible for qlikserver version 12.0.20400.0 ?

Currently Iam using qlikview desktop version 12.10.0.0

Re: Data not displaying in Nprinting reports

Ruggero_Piccoli — Wed, 10 Jun 2020 13:38:57 GMT

Hi,

Also when you use a server (qvp) connection Qlik NPrinting Engine will open the local QlikView Desktop installation so it must have an active license. If in that moment the leased license will not be available the reports generation will fail.

The QlikView Desktop installed in all the computers where you are running Qlik NPrinting Engines must be at the same version of the QlikView server where the QVWs are. So I think you only need to upgrade the local QlikView Desktop installation.

Best Regards,

ruggero

Re: Data not displaying in Nprinting reports

Lech_Miszkiewicz — Wed, 10 Jun 2020 23:21:31 GMT

I guess we stop here. First you need to make sure your environment is supported. Looking at the whole conversation it feels like it has never been verified and tested and it is not that your report is not working. I think nothing is properly working there or is not stable.

Your environmnet is: QlikView server is v12.0 SR5 12.0.20400.0 your QlikView desktop is v12.1 Initial release 12.10.0.0 which is also not supported.

NPrinting supports only versions listed in documentation:

https://help.qlik.com/en-US/nprinting/February2020/Content/NPrinting/DeployingQVNprinting/System-requirements_engine.htm

My piece of advice is:

Go through documentation
Create supported environment (this will require you to upgrade server and desktops)
Check all other requirements for Server, Engine, Designer, OS, User accounts etc - it is all in help so there is no point to write it again here
Once you have all setup we can come back to your issue - what do you say?

btw - there is no shortcuts here. I learned my lesson hard way and saying that "it actually works" with other templates or other connection type is not an excuse. If it is not supported - it is not supported - full stop.

cheers and good luck.