Skip to main content

Qlik

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: 
Aditya_Chitale
Specialist
Specialist
‎2023-01-23 12:45 AM

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)
Labels
938 Views
0 Likes
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support
‎2023-01-26 09:49 AM

In response to Aditya_Chitale

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

741 Views
10 Replies
Ruggero_Piccoli
Support
Support
‎2023-01-23 04:34 AM

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.
843 Views
0 Likes
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2023-01-23 08:14 AM

In response to Ruggero_Piccoli

@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.
833 Views
Ruggero_Piccoli
Support
Support
‎2023-01-23 09:56 AM

In response to Lech_Miszkiewicz

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.
829 Views
0 Likes
Frank_S
Support
Support
‎2023-01-23 01:25 PM

@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 for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
SalesDemoShdSp.qvf
821 Views
0 Likes
Aditya_Chitale
Specialist
Specialist
‎2023-01-24 07:04 AM
Author

In response to Frank_S

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

test pivot nprinting.qvf
803 Views
0 Likes
Frank_S
Support
Support
‎2023-01-24 02:14 PM

In response to Aditya_Chitale

@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 for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
790 Views
0 Likes
Aditya_Chitale
Specialist
Specialist
‎2023-01-25 12:44 AM
Author

In response to Frank_S

@Frank_S 

Please find attached Nprinting report and qvf used.

Regaards,

Aditya

Test_Aditya_2023-01-25T05-29-59-Z_Excel.zip
Test App Aditya.qvf
776 Views
0 Likes
Frank_S
Support
Support
‎2023-01-25 11:55 AM

In response to Aditya_Chitale

Thanks! Were checking and will get back to you.

Kind regards...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
758 Views
0 Likes
Ruggero_Piccoli
Support
Support
‎2023-01-26 09:49 AM

In response to Aditya_Chitale

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.
742 Views