topic Re: Nprinting- Column labels with variables is not pulling through correctly in excel report in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-Column-labels-with-variables-is-not-pulling-through/m-p/111624#M4011 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P></P><P>Best Regards,</P><P>Ruggero</P><P>---------------------------------------------</P><P><SPAN>When applicable please mark the appropriate replies as CORRECT </SPAN><A class="jive-link-wiki-small" data-containerid="2001" data-containertype="14" data-objectid="14806" data-objecttype="102" href="https://community.qlik.com/docs/DOC-14806">https://community.qlik.com/docs/DOC-14806</A><SPAN>. 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.</SPAN></P></BODY></HTML> Thu, 25 Oct 2018 09:10:02 GMT Ruggero_Piccoli 2018-10-25T09:10:02Z Nprinting- Column labels with variables is not pulling through correctly in excel report https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-Column-labels-with-variables-is-not-pulling-through/m-p/111623#M4010 <HTML><HEAD></HEAD><BODY><P>When pulling across an entire table , the variables in the column headers work correctly. eg. last or prior year becomes 2017 as below.</P><P></P><P><IMG __jive_id="216090" alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/216090_1.png" style="width: 620px; height: 349px;" /></P><P><IMG __jive_id="216091" alt="2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/216091_2.png" style="width: 620px; height: 349px;" /></P><P></P><P>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.</P><P><IMG __jive_id="216092" alt="3.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/216092_3.png" style="width: 620px; height: 349px;" /></P><P><IMG __jive_id="216093" alt="4.png" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/216093_4.png" style="width: 620px; height: 349px;" /></P><P>Does the column header have to manually edited?</P></BODY></HTML> Wed, 17 Oct 2018 09:58:02 GMT https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-Column-labels-with-variables-is-not-pulling-through/m-p/111623#M4010 insightconsulti 2018-10-17T09:58:02Z Re: Nprinting- Column labels with variables is not pulling through correctly in excel report https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-Column-labels-with-variables-is-not-pulling-through/m-p/111624#M4011 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P></P><P>Best Regards,</P><P>Ruggero</P><P>---------------------------------------------</P><P><SPAN>When applicable please mark the appropriate replies as CORRECT </SPAN><A class="jive-link-wiki-small" data-containerid="2001" data-containertype="14" data-objectid="14806" data-objecttype="102" href="https://community.qlik.com/docs/DOC-14806">https://community.qlik.com/docs/DOC-14806</A><SPAN>. 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.</SPAN></P></BODY></HTML> Thu, 25 Oct 2018 09:10:02 GMT https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-Column-labels-with-variables-is-not-pulling-through/m-p/111624#M4011 Ruggero_Piccoli 2018-10-25T09:10:02Z