Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
insightconsulti
Partner - Contributor
Partner - Contributor

Nprinting- Column labels with variables is not pulling through correctly in excel report

When pulling across an entire table , the variables in the column headers work correctly. eg. last or prior year becomes 2017 as below.

1.png

2.png

However, when brining in the individual columns the column label or header stays as PY prior year and the variable is not working to give 2017.

3.png

4.png

Does the column header have to manually edited?

1 Reply
Ruggero_Piccoli
Support
Support

Hi,

Yes, you have to remove the column header dropped from the table, create a formula that calculate it and drag and drop that formula as new column header.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



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.