Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
krmvacar
Creator II
Creator II
‎2023-04-24 03:38 AM

Selecting field in nprinting pivot table

Hi All ,

My Nprinting version september 2020.Qlikview version April 2019. 

I have a pivot table and I don't want to send specific dimensions in this pivot table. But I can't select dimensions, why? Your help is welcome. I can select on Qliksense but not on qlikview

Thank you so much.

krmvacar_0-1682321416940.png

 

Labels (2)
Labels
490 Views
0 Likes
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support
‎2023-04-24 05:22 AM

Hi,

This is Work as Design. You can add a QlikView pivot table only as a single tag and the whole fields will be exported.

You can:

  1. clone the pivot in QlikView
  2. transform the clone into a straight table 
  3. save the QVW
  4. reload the Qlik NPrinting connection cache 
  5. close and reopen the Qlik NPrinting Designer
  6. add the new straight table
  7. create a native Excel pivot table as explained in https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm. Pay attention to do all the listed steps because the most common error is to skip some of them and in that case you will not have the result you expect

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

465 Views
1 Reply
Ruggero_Piccoli
Support
Support
‎2023-04-24 05:22 AM

Hi,

This is Work as Design. You can add a QlikView pivot table only as a single tag and the whole fields will be exported.

You can:

  1. clone the pivot in QlikView
  2. transform the clone into a straight table 
  3. save the QVW
  4. reload the Qlik NPrinting connection cache 
  5. close and reopen the Qlik NPrinting Designer
  6. add the new straight table
  7. create a native Excel pivot table as explained in https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm. Pay attention to do all the listed steps because the most common error is to skip some of them and in that case you will not have the result you expect

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
466 Views