topic Re: Nprinting Pivot table presentation in Qlik NPrinting

Nprinting Pivot table presentation

Alma1234 — Sat, 16 Nov 2024 04:20:11 GMT

Hi There,

I am using a nprinting june 2018 and trying to insert a pivot table.

I wants the pivot to looks like the picture, it does in qlikview

but when inserting to nprint the dimension repeat each time like (attached in word). The dimension repeats itself

I tried addvalue function, pick function and editing the script so it will come as strait dimension -

They all works in qlikview but not in nprinting. Any Ideas?

Re: Nprinting Pivot table presentation

sivakumar1994 — Tue, 26 Feb 2019 19:28:17 GMT

please attach the pic for reference

Re: Nprinting Pivot table presentation

Frank_S — Tue, 26 Feb 2019 19:36:15 GMT

I suggest that you do the following in order that we can better understand your requirement:

Create a sample QVW or use the attached Qlik salesdemo.qvw.

To illustrate your requirement:

Create a NP report template and show us an image snapshot of the template
Preview the report
What are your expected results? Show us an image
What are your actual results? Show us an image

This will better help us to understand what you are trying to accomplish to meet your requirement so a solution might be provided in this forum.

Thank you.

Re: Nprinting Pivot table presentation

Lech_Miszkiewicz — Tue, 26 Feb 2019 22:57:31 GMT

agree with Frank,

also. Is your intend to use image of your QlikView object or row data. If you want to use row data (from your QlikView Pivot Table) i have a bad news - it will repeat value on each row - this is how it is - end of story.

There are workarounds for it, but they will depend on how you want your final report to look like. If it has only few columns - you may be able to mimick pivot view using set analysis and make fonts and background in the same colour to imitate Pivot Table view...

I will not elaborate on it more, as we need first your detailed input as @Frank_S mentioned.

cheers

Re: Nprinting Pivot table presentation

Alma1234 — Wed, 27 Feb 2019 06:34:58 GMT

Hi,

I attach the desired pivot

Regards,

Re: Nprinting Pivot table presentation

Alma1234 — Wed, 27 Feb 2019 07:32:14 GMT

Hi,

Thanks for the explanations.

Attach the qvw with the desired pivot table (as in the png pivot_qvw)

The attached power point is how it looks in the nprinting when i attach as a table to npritning.

The only problem that it say 9 times Sales and 9 time Finance

It also reverse the table to the right side but this is good for me.

Hope it is now better understood.

Cheers,

Limor

Re: Nprinting Pivot table presentation

Alma1234 — Wed, 27 Feb 2019 07:32:50 GMT

Re: Nprinting Pivot table presentation

Alma1234 — Wed, 27 Feb 2019 07:33:41 GMT

The presentation

Re: Nprinting Pivot table presentation

Alma1234 — Wed, 27 Feb 2019 08:25:00 GMT

Thanks Lech,
You mean by mimick is adding a table by pixel perfect report?
I have one pivot with 5 rows. i couldn't find the workarounds. do you mean to add a table
and than the headers will be the columns from pivot table?

Cheers,
Limor

Re: Nprinting Pivot table presentation

Lech_Miszkiewicz — Wed, 27 Feb 2019 08:36:59 GMT

no,

what i meant was to create straight table with constant number of columns and set analysis to calculate required expressions

.So,

I do not see it working if you have variable number of departments. On the other hand if there is always the same number of departments, you could create a straight table with measures using set analysis for each department/period-type.

I know it will be more work, but at least you could create those required groupings.

In other words: column headers would always be static and would be build directly in PPT template, and only values would be populated directly from Qlik

Re: Nprinting Pivot table presentation

Alma1234 — Wed, 27 Feb 2019 09:05:04 GMT

Thanks, sound like a good option. however for this practicality ppt i need about 20 pivot tables so it will be around 1000 different expressions ...

Re: Nprinting Pivot table presentation

Lech_Miszkiewicz — Wed, 27 Feb 2019 09:08:47 GMT

by the way, can't you use images of pivot table instead of data?

Re: Nprinting Pivot table presentation

Alma1234 — Wed, 27 Feb 2019 12:38:15 GMT

Hi, I tried to insert 400% in export of qlikview and very high in nprinting report - but it still not as clear as the table when printing.