https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-Pivot-Table/m-p/1759122#M30472 <P>Pivot tables in HTML are not easy to build and whole code (in my opinion) must come from Qlik application directly</P><P>Example here:&nbsp;<A href="https://nprintingadventures.com/2020/04/24/how-to-build-html-pivot-table-in-nprinting/" target="_blank" rel="noopener">https://nprintingadventures.com/2020/04/24/how-to-build-html-pivot-table-in-nprinting/</A></P><P>btw... there is no one piece of code we can give you - it will be purely based on requirements so you may want to share mockup of final outcome identifying what is dynamic (number of grouped dimensions in rows and columns etc...)</P> Thu, 05 Nov 2020 21:54:29 GMT Lech_Miszkiewicz 2020-11-05T21:54:29Z https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-Pivot-Table/m-p/1758984#M30470 <P>Hello experts I need your help with creating an NPrinting pivot table. Below is the code I have so far which gives me a straight table but I need it to be&nbsp; a pivot table.</P><P>&lt;!DOCTYPE html&gt;<BR />&lt;html&gt;<BR />&lt;head&gt;<BR />&lt;style&gt;<BR />table, td,th {<BR />border: 1px solid black;<BR />}<BR />&lt;/style&gt;<BR />&lt;/head&gt;<BR />&lt;body&gt;</P><P>&lt;table&gt;<BR />&lt;tr&gt;<BR />&lt;th&gt;Quarter&lt;/th&gt;<BR />&lt;th&gt;Position&lt;/th&gt;<BR />&lt;th&gt;Goal This Q&lt;/th&gt;<BR />&lt;th&gt;Apps This Q&lt;/th&gt;<BR />&lt;th&gt;Goal Met This Q&lt;/th&gt;<BR />&lt;th&gt;2020 Goal&lt;/th&gt;<BR />&lt;th&gt;2020 Apps for SMP&lt;/th&gt;<BR />&lt;th&gt;Percentage Goal Met&lt;/th&gt;<BR />&lt;th&gt;Number Accepted 2020&lt;/th&gt;<BR />&lt;th&gt;Accepted Percentage&lt;/th&gt;</P><P>&lt;/tr&gt;<BR />&lt;tr&gt;<BR />&lt;td&gt;%%Quarter%%&lt;/td&gt;<BR />&lt;td&gt;%%=[Role Group]%%&lt;/td&gt;<BR />&lt;td&gt;%%Sum({_Quarter={"$(vQuarter)"}_} Goals)%%&lt;/td&gt;<BR />&lt;td&gt;%%=COUNT({_Goals={"_0"},Year={'2020'},Quarter={"$(vQuarter)"}_}[Applicant ID])%%&lt;/td&gt;<BR />&lt;td&gt;%%Count({$_Goals={"_0"}, Year={'2020'}, Quarter={"$(vQuarter)"}_}[Applicant ID]) / Sum({$_[Applicant Submit Date]=,Quarter={"$(vQuarter)"}_} [Goals])%%&lt;/td&gt;<BR />&lt;td&gt;%%if($(vApplicationCount) _ 0 or $(vApplicationGoals) _0,Sum({$_[Applicant Submit Date]=,Year=, [Quarter]=_} [Goals]))%%&lt;/td&gt;<BR />&lt;td&gt;%%Count({$_Goals={"_0"},Year={'2020'},Quarter=_}[Applicant ID])%%&lt;/td&gt;<BR />&lt;td&gt;%%Count({$_Goals={"_0"},Year={'2020'},Quarter=_}[Applicant ID]) / if($(vApplicationCount) _ 0 or $(vApplicationGoals) _0,Sum({$_[Applicant Submit Date]=,Year=, [Quarter]=_} [Goals]))%% &lt;/td&gt;<BR />&lt;td&gt;%%Count({_[Current Status ID]={2}_}[Applicant ID])%%&lt;/td&gt;<BR />&lt;td&gt;%%Count({_[Current Status]={'Accepted'}_}[Applicant ID])/Count({$_Goals={"_0"},Year={'2020'},Quarter=_}[Applicant ID])%%&lt;/td&gt;<BR />&lt;/tr&gt;<BR />&lt;/table&gt;</P><P>&lt;/body&gt;<BR />&lt;/html&gt;</P><P>The output is a straight table which looks like this</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pomna_1-1604590771621.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/43629iF5A770F0B7D5A6F3/image-size/medium?v=v2&amp;px=400" role="button" title="Pomna_1-1604590771621.png" alt="Pomna_1-1604590771621.png" /></span></P><P>&nbsp;</P><P>But I need a pivot table . Any suggestions will be appreciated.</P><P>&nbsp;</P> Thu, 05 Nov 2020 15:41:41 GMT https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-Pivot-Table/m-p/1758984#M30470 Pomna 2020-11-05T15:41:41Z https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-Pivot-Table/m-p/1759122#M30472 <P>Pivot tables in HTML are not easy to build and whole code (in my opinion) must come from Qlik application directly</P><P>Example here:&nbsp;<A href="https://nprintingadventures.com/2020/04/24/how-to-build-html-pivot-table-in-nprinting/" target="_blank" rel="noopener">https://nprintingadventures.com/2020/04/24/how-to-build-html-pivot-table-in-nprinting/</A></P><P>btw... there is no one piece of code we can give you - it will be purely based on requirements so you may want to share mockup of final outcome identifying what is dynamic (number of grouped dimensions in rows and columns etc...)</P> Thu, 05 Nov 2020 21:54:29 GMT https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-Pivot-Table/m-p/1759122#M30472 Lech_Miszkiewicz 2020-11-05T21:54:29Z