topic Re: Piramide graph in NPrinting in Qlik NPrinting

Piramide graph in NPrinting

tsionalush — Thu, 01 Sep 2022 22:46:46 GMT

Hi all,

I´m having an issue when exporting from qlikview a piramide graph where the values on the X axis should all be positive as the grapg represnts the distribution of the population per sex and age.
The values within qliview are presented as expected with positive values on the X axis, but when exported to NPrinting as an image, the values to the left of the 0 on the X axis are presented in negative values.

Is anyone experienced this issue or have a solution?

TNX

Re: Piramide graph in NPrinting

Frank_S — Fri, 12 Aug 2022 19:51:09 GMT

Can you provide some snapshots of:

1. Expected results

2. Actual results

3. Steps you have tried or additional descriptive images.

Also in case you weren't looped in, NP 16.x track has be deprecated from support since March 31, 2020.

Here is the migration article if you are considering an upgrade (which I would highly urge so you can get onto a supported product as soon as possible).

NPrinting 16 to NPrinting 19+ Migration Playbook - Qlik Community - 1780278

Kind regards...

Re: Piramide graph in NPrinting

David_Friend — Tue, 16 Aug 2022 19:28:38 GMT

@tsionalush like Frank said, NP 16.9 is really old, we no longer support it, I'm also curious what version is QlikView.

Re: Piramide graph in NPrinting

tsionalush — Wed, 17 Aug 2022 07:45:38 GMT

Hi,

Sorry, the version of the NPrinting is 19.

In qlikvie the graph looks like this, and this is the expected resault:

the actual resault from the report created with NPrinting is:

As you can see the values on the left on the X axis are presented in negative and not in positive as expected and presented in QlikView.

Any thoughts?

Re: Piramide graph in NPrinting

Frank_S — Wed, 17 Aug 2022 17:05:24 GMT

Can you provide a sample QVW that contains this or similar chart along with an exported copy of your NP report?

We can look at it directly this way to provide some feedback.

It's not clear what your source data is actually formatted as so we need to check it.

In the meantime, what happens if you right click on the QlikView object in your QVW and export it as an image? Do you get the same result as the NP report?
We can check this too if you can provide a sample QVW that exhibits the same behavior.

Kind regards...

Re: Piramide graph in NPrinting

tsionalush — Fri, 19 Aug 2022 11:05:42 GMT

Hi Frank,

Please find attached an example qlikview with the graph mentioned and the report created with NPrinting.

btw, when exporting as an image from qlikview the graph looks as expected with NO negative values

Tnx

Re: Piramide graph in NPrinting

David_Friend — Fri, 19 Aug 2022 17:43:33 GMT

@tsionalush thanks I'll try and replicate it in a test system, so your NPrinting version is May 2021, what version is QlikView on?

Re: Piramide graph in NPrinting

David_Friend — Fri, 19 Aug 2022 18:29:15 GMT

@tsionalush I tested using your QVW in my May 2021 system, as an HTML report the chart looks identical. I added the chart as an Image.

Can you export your report template, click the 'Export' button when you are editing your report in NP webconsole, it will generate a ZIP file.

Re: Piramide graph in NPrinting

Frank_S — Fri, 19 Aug 2022 19:25:18 GMT

Well I did tests with your QVW @tsionalush

Your QVW does have negative value on the x-axis (right)
those negative values also get reported the NPrinting report output (upper left)
report template (lower left)

So I'm not able to reproduce the issue since NPrinting is exporting the results as seen in the QVW.

Re: Piramide graph in NPrinting

David_Friend — Tue, 23 Aug 2022 18:55:18 GMT

@tsionalush so both Frank and I could not reproduce your issue, if you can do an export of your report template we can try and import and test it.

Re: Piramide graph in NPrinting

tsionalush — Mon, 29 Aug 2022 09:51:04 GMT

Hi,

Sorry I couldn´t respond before.

In the qvw I attached I don´t have negative value since i´m using the number formatting:

So i´m not sure why when you open the file it presents to you negative values.

Could you please tell me how do I export the file in Zip as you asked?

Tnx

Re: Piramide graph in NPrinting

Lech_Miszkiewicz — Mon, 29 Aug 2022 22:52:25 GMT

Hi,

I would assume this could be a problem with regional settings (number formats) on your NPrinting server. First thing to check would be:

logon as service account to your NPrinting engine server
open QlikView desktop and open your application
observer results - do you get expected results?

If you get expected results I would then repeat the same steps using "Open in server" option when opening qvw.

thanks

Lech

Re: Piramide graph in NPrinting

tsionalush — Wed, 31 Aug 2022 15:02:34 GMT

Hi,

Just found out how to export the zip file.

Please find it attached. Hope it can help find the problem.

Re: Piramide graph in NPrinting

Frank_S — Thu, 01 Sep 2022 22:54:54 GMT

Same result when using the Word report that you shared with us.

This appears to be working as designed.

Re: Piramide graph in NPrinting

tsionalush — Mon, 19 Sep 2022 10:56:02 GMT

Hi Frank,

I can see in the screenshot you sent that the report from NPrinting also has negative values (fot males).

I´m trying to present those values in positive and still leave them left to the '0'. In qlik i´m succeeding doing so using the 'Number' tab and the format number to show absolute values.

Could you get to present this graph in nprinting with positive values only (as the qvw file has)?

Re: Piramide graph in NPrinting

Lech_Miszkiewicz — Mon, 19 Sep 2022 12:38:54 GMT

Hi, As I mentioned before - there is something wrong with the settings you are using or maybe regional settings or maybe compatibility issue regarding QlikView, QlikView Desktop and NPrinting. Hard to say. Using latest versions of software you can see below the results. I just took your qvw file from this post, throw it into word template and result you can see below - working as expected.

cheers

Lech

Re: Piramide graph in NPrinting

tsionalush — Wed, 21 Sep 2022 09:51:53 GMT

Hi,

Could you please explain in more details how can I check the compatibility between qvw and NPrinting regarding the regional settings ans number formatting?

Tnx

Re: Piramide graph in NPrinting

Lech_Miszkiewicz — Wed, 21 Sep 2022 10:53:19 GMT

I didn't say compatibility between qvw and NPrinting - I asked to check regional settings and I also asked another questions in my previous post which would help identify problem. Have you done that and could you provide us with the results of those test?

Then you can also do following:

Check what are the OS regional settings on NPrinting engine machine
Check if version of QlikView (server and desktop) you are using is compatible with the version of NPrinting (this is documented on https://help.qlik.com)
- What version are you using?
What NPrinting connection to QlikView (LOCAL or SERVER) are you using?

cheers