https://community.qlik.com/t5/Member-Articles/How-to-work-around-formatting-QlikView-or-Qlik-Sense-Pivot-Table/ta-p/1580577 <P>Unfortunately it's not possible to manage field level formatting with a QlikView or Qlik Sense Pivot Table since the entire chart is exported from Qlik Sense (or QlikView) as is rather than the individual fields within the pivot table.</P> <P>To work around this:</P> <UL> <LI>In QlikView/Qlik Sense, create a clone/copy of your original pivot table and convert the copy to a straight table.</LI> <LI>Save your Qlik Sense or QlikView app, reload the NPrinting meta data so that the new cloned, newly created or copied straight table chart is available to NPrinting</LI> <LI>Use the straight table chart, now visible to NPrinting after the metadata reload, to create a Pivot Table with QS or QV data by following the instructions one of the links below:</LI> </UL> <P><A href="https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ExcelReports/Excel-pivot-table-report.htm" target="_blank" rel="nofollow noopener noreferrer">https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ExcelReports/Excel-pivot-table-rep...</A></P> <P><A href="https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm" target="_blank" rel="nofollow noopener noreferrer">https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm</A></P> <P>This approach is common when it is necessary to have a greater level of control of field level formatting as a report developer. This when permissions to format the source pivot table in Qlik Sense or QlikView are limiited or simply require&nbsp; a separate pivot view that is different to the QV or QS chart without changing the source chart.</P> Thu, 23 May 2019 22:51:18 GMT Frank_S 2019-05-23T22:51:18Z https://community.qlik.com/t5/Member-Articles/How-to-work-around-formatting-QlikView-or-Qlik-Sense-Pivot-Table/ta-p/1580577 <P>Unfortunately it's not possible to manage field level formatting with a QlikView or Qlik Sense Pivot Table since the entire chart is exported from Qlik Sense (or QlikView) as is rather than the individual fields within the pivot table.</P> <P>To work around this:</P> <UL> <LI>In QlikView/Qlik Sense, create a clone/copy of your original pivot table and convert the copy to a straight table.</LI> <LI>Save your Qlik Sense or QlikView app, reload the NPrinting meta data so that the new cloned, newly created or copied straight table chart is available to NPrinting</LI> <LI>Use the straight table chart, now visible to NPrinting after the metadata reload, to create a Pivot Table with QS or QV data by following the instructions one of the links below:</LI> </UL> <P><A href="https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ExcelReports/Excel-pivot-table-report.htm" target="_blank" rel="nofollow noopener noreferrer">https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ExcelReports/Excel-pivot-table-rep...</A></P> <P><A href="https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm" target="_blank" rel="nofollow noopener noreferrer">https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm</A></P> <P>This approach is common when it is necessary to have a greater level of control of field level formatting as a report developer. This when permissions to format the source pivot table in Qlik Sense or QlikView are limiited or simply require&nbsp; a separate pivot view that is different to the QV or QS chart without changing the source chart.</P> Thu, 23 May 2019 22:51:18 GMT https://community.qlik.com/t5/Member-Articles/How-to-work-around-formatting-QlikView-or-Qlik-Sense-Pivot-Table/ta-p/1580577 Frank_S 2019-05-23T22:51:18Z