topic [NPrinting 16.6] Individual format for columns in PowerPoint-Template in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-16-6-Individual-format-for-columns-in-PowerPoint/m-p/42933#M1581 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm trying to create a table in PowerPoint which has different number formattings for each column. Unfortunatly I'm not very successful.</P><P>Disclaimer: I need both 'Format' and 'Custom Rows' which prevents me from inserting the individual columns instead of the whole table.</P><P>I'm using Nprinting 16.6.0.0 (SR6) with QlikView 12.10.20000.0 (SR2)</P><P></P><P>I'm getting following table</P><P></P><P><IMG alt="qv_q4_1.png" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/192286_qv_q4_1.png" style="height: 119px; width: 620px;" /></P><P></P><P>What I'm trying to get ist this table</P><P><IMG alt="qv_q7.png" class="image-5 jive-image" src="https://community.qlik.com/legacyfs/online/192287_qv_q7.png" style="height: 115px; width: 620px;" /></P><P>In the powerpoint template this table looks like the following</P><P><IMG alt="qv_q4.png" class="jive-image image-6" src="https://community.qlik.com/legacyfs/online/192288_qv_q4.png" style="height: 147px; width: 620px;" /></P><P></P><P>As an example the properties for the CpSES column</P><P><SPAN style="font-size: 13.3333px;">That's my structure. The table CH23_1 is the one I'm referring to in the powerpoint template. The column I'm trying to get into the format '#,##0.00 €' is CpSES.</SPAN></P><P><IMG alt="qv_q1.png" class="jive-image image-7" src="https://community.qlik.com/legacyfs/online/192289_qv_q1.png" style="height: auto;" /></P><P>The properties for the CH23_1. I unchecked the 'Keep Source Formats'. As you can see I also specified 'Custom Rows'. As I read in the <A href="https://help.qlik.com/en-US/nprinting/September2017/Content/PowerPointReports/HowInsertNativeTablePowerPointReports/Native-table.htm">help.qlik.com</A> section this setting is only available for whole tables and are not available for single columns. So I'm stuck with the whole table. </P><P><IMG alt="qv_q2.png" class="image-8 jive-image" src="https://community.qlik.com/legacyfs/online/192290_qv_q2.png" style="height: auto;" /></P><P></P><P>The properties for the CpSES column. 'Keep Source Formats' is also unchecked. The format is given. </P><P><IMG alt="qv_q3.png" class="image-9 jive-image" src="https://community.qlik.com/legacyfs/online/192291_qv_q3.png" style="height: auto;" /></P><P></P><P>As you may see in the desired table at the beginning of the post I want different formats for the individual columns. some are '#,##0', some are '#,##0.00 %' and some are '#,##0.00 €'.</P><P></P><P>Is it possible to achieve this or am I out of luck?</P></BODY></HTML> Fri, 02 Feb 2018 10:53:53 GMT Anonymous 2018-02-02T10:53:53Z [NPrinting 16.6] Individual format for columns in PowerPoint-Template https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-16-6-Individual-format-for-columns-in-PowerPoint/m-p/42933#M1581 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm trying to create a table in PowerPoint which has different number formattings for each column. Unfortunatly I'm not very successful.</P><P>Disclaimer: I need both 'Format' and 'Custom Rows' which prevents me from inserting the individual columns instead of the whole table.</P><P>I'm using Nprinting 16.6.0.0 (SR6) with QlikView 12.10.20000.0 (SR2)</P><P></P><P>I'm getting following table</P><P></P><P><IMG alt="qv_q4_1.png" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/192286_qv_q4_1.png" style="height: 119px; width: 620px;" /></P><P></P><P>What I'm trying to get ist this table</P><P><IMG alt="qv_q7.png" class="image-5 jive-image" src="https://community.qlik.com/legacyfs/online/192287_qv_q7.png" style="height: 115px; width: 620px;" /></P><P>In the powerpoint template this table looks like the following</P><P><IMG alt="qv_q4.png" class="jive-image image-6" src="https://community.qlik.com/legacyfs/online/192288_qv_q4.png" style="height: 147px; width: 620px;" /></P><P></P><P>As an example the properties for the CpSES column</P><P><SPAN style="font-size: 13.3333px;">That's my structure. The table CH23_1 is the one I'm referring to in the powerpoint template. The column I'm trying to get into the format '#,##0.00 €' is CpSES.</SPAN></P><P><IMG alt="qv_q1.png" class="jive-image image-7" src="https://community.qlik.com/legacyfs/online/192289_qv_q1.png" style="height: auto;" /></P><P>The properties for the CH23_1. I unchecked the 'Keep Source Formats'. As you can see I also specified 'Custom Rows'. As I read in the <A href="https://help.qlik.com/en-US/nprinting/September2017/Content/PowerPointReports/HowInsertNativeTablePowerPointReports/Native-table.htm">help.qlik.com</A> section this setting is only available for whole tables and are not available for single columns. So I'm stuck with the whole table. </P><P><IMG alt="qv_q2.png" class="image-8 jive-image" src="https://community.qlik.com/legacyfs/online/192290_qv_q2.png" style="height: auto;" /></P><P></P><P>The properties for the CpSES column. 'Keep Source Formats' is also unchecked. The format is given. </P><P><IMG alt="qv_q3.png" class="image-9 jive-image" src="https://community.qlik.com/legacyfs/online/192291_qv_q3.png" style="height: auto;" /></P><P></P><P>As you may see in the desired table at the beginning of the post I want different formats for the individual columns. some are '#,##0', some are '#,##0.00 %' and some are '#,##0.00 €'.</P><P></P><P>Is it possible to achieve this or am I out of luck?</P></BODY></HTML> Fri, 02 Feb 2018 10:53:53 GMT https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-16-6-Individual-format-for-columns-in-PowerPoint/m-p/42933#M1581 Anonymous 2018-02-02T10:53:53Z Re: [NPrinting 16.6] Individual format for columns in PowerPoint-Template https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-16-6-Individual-format-for-columns-in-PowerPoint/m-p/42934#M1582 <HTML><HEAD></HEAD><BODY><P>The help page is either outdated or plain wrong. The individual formatting is working if you insert each column of the table on its position in the powerpoint. The 'Custom Rows' part is also working - despite being otherwise stated in the Qlik help page.</P><P></P><P>That was time not well spent...</P></BODY></HTML> Wed, 07 Feb 2018 09:17:44 GMT https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-16-6-Individual-format-for-columns-in-PowerPoint/m-p/42934#M1582 Anonymous 2018-02-07T09:17:44Z