Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Alma1234
Contributor III
Contributor III

Nprinting Pivot table presentation

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? 

 

1 Solution

Accepted Solutions
Lech_Miszkiewicz

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

12 Replies
sivakumar1994
Contributor III
Contributor III

please attach the pic for reference
Frank_S
Support
Support

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.

 

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Lech_Miszkiewicz

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Alma1234
Contributor III
Contributor III
Author

Hi,

I attach the desired pivot

Regards,

Alma1234
Contributor III
Contributor III
Author

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

 

Alma1234
Contributor III
Contributor III
Author

 
Alma1234
Contributor III
Contributor III
Author

The presentation

Alma1234
Contributor III
Contributor III
Author

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
Lech_Miszkiewicz

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post