Skip to main content

Qlik NPrinting

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Aditya_Chitale
Creator III
Creator III

Pivot formatting changes when report is previewed

Hello All,

I have a excel template in which I have created a pivot table using QlikSense straight table data source. Here, I have selected the option "Merge & center cells with labels". But when the report is previewed, the last column group does not center the header. The header gets centered only when I interact with the pivot like collapsing the rows.

I have unchecked keep source formatting option. Any solution on this ?

Aditya_Chitale_0-1674452016147.png

Before collapsing rows,  column header always remains unmerged for last column.

Aditya_Chitale_2-1674452369434.png

After Collapsing rows, formatting gets applied and column header properly merged for all 3 columns.

Aditya_Chitale_3-1674452579764.png

 

Regards,

Aditya

 

 

Labels (2)
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

Hi,

Thanks for sharing the files. I tested them and I find that you skip some steps in building the pivot:

Ruggero_Piccoli_0-1674744463784.png

They are documented in https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm

After setting those options the pivot is created correctly:

Ruggero_Piccoli_1-1674744555817.png

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

10 Replies
Ruggero_Piccoli
Support
Support

Hi,

Qlik NPrinting does its best effort to keep the source format but it is not always possible. You can open a support ticket with everything we need to reproduce so a developer can check it.

A workaround could be to create a native Excel pivot table starting from a Qlik Sense straight table and apply native Excel formatting.

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.
Lech_Miszkiewicz

@Ruggero_Piccoli  Looks like @Aditya_Chitale  is already doing it-he builds native pivot table from Qlik Sense straight table. 

I would need to do some testing, however I am little bit short of time nowadays as i am going on holidays. 

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.
Ruggero_Piccoli
Support
Support

Hi,

I'm not able to reproduce it. I suggest you to open a support ticket with everything we need to reproduce the issue.

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.
Frank_S
Support
Support

@Aditya_Chitale


Are you using NPrinting chart tags in the cells that are becoming unmerged? or Just manually typed column information? What exactly have you placed in the cells that are becoming unmerged?

  • Is it a calculated dimension from the source QVF table by any chance?

If you can provide a copy of the report and a QVF we can use to reproduce the issue please upload it hear. Make sure to use sample data. See attached if that helps.

 

Kind regards...

Please remember hit the 'Like' button and make helpful answers as 'Solution Accepted'... Cheers!
Aditya_Chitale
Creator III
Creator III
Author

Hi @Frank_S ,

I am using calculated measure from Qlik Sense in my Nprinting Native pivot table. Kindly find attached test qvf to replicate the scenerio.

Below is the screenshot of Nprinting report generated using attached test qvf.

Aditya_Chitale_0-1674561844518.png

 

Regards,

Aditya

Frank_S
Support
Support

@Aditya_Chitale 

Open and Export the NP report from the NP web console. and attach it here as well but more importantly to better understand the scenario and how you have constructed the report.

Follow these instructions if needed:

Once you upload it here, I will use the exported NP report with the attached QVF to test. 
I also need to check using a calculated column is supported. 

In that case you may want to proactively load your calculated data into the load script of the QVF. 

Then reload the QVF in the NP web console after making changes to it.

Please remember hit the 'Like' button and make helpful answers as 'Solution Accepted'... Cheers!
Aditya_Chitale
Creator III
Creator III
Author

@Frank_S 

Please find attached Nprinting report and qvf used.

Regaards,

Aditya

Frank_S
Support
Support

Thanks! Were checking and will get back to you.

Kind regards...

Please remember hit the 'Like' button and make helpful answers as 'Solution Accepted'... Cheers!
Ruggero_Piccoli
Support
Support

Hi,

Thanks for sharing the files. I tested them and I find that you skip some steps in building the pivot:

Ruggero_Piccoli_0-1674744463784.png

They are documented in https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm

After setting those options the pivot is created correctly:

Ruggero_Piccoli_1-1674744555817.png

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.