https://community.qlik.com/t5/App-Development/Exporting-Pivot-Table-to-Excel-is-Formatted-as-Text/m-p/1520789#M37285 <P>can you provide more details or sample qvf as it is not easy to be reproduced.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/2184i73A8967A4F0D7CF6/image-size/medium?v=v2&amp;px=400" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>&nbsp;</P><P>ZZ</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 14 Dec 2018 02:43:27 GMT zzyjordan 2018-12-14T02:43:27Z https://community.qlik.com/t5/App-Development/Exporting-Pivot-Table-to-Excel-is-Formatted-as-Text/m-p/1520781#M37283 <P>Looking for some feedback.&nbsp; I tried applying the suggestion from&nbsp;a few different QlikView threads&nbsp;using a Round() function within an expression without luck (output is still formatted as text).</P><P><STRONG>Qlik Sense App:</STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="PivotTableSense.png" style="width: 510px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/2182i647F5F821A86FFBE/image-size/large?v=v2&amp;px=999" role="button" title="PivotTableSense.png" alt="PivotTableSense.png" /></span></P><P><STRONG>Excel Output:</STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="PivotTableExcel.png" style="width: 196px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/2181i44905B04F57A4911/image-size/large?v=v2&amp;px=999" role="button" title="PivotTableExcel.png" alt="PivotTableExcel.png" /></span></P><P>&nbsp;</P><P>We have no problems exporting from a standard table object as a value but the pivot table object is exporting only as text and I'm hoping there is an easy workaround for this.</P><P>Many thanks in advance.</P> Fri, 14 Dec 2018 00:18:33 GMT https://community.qlik.com/t5/App-Development/Exporting-Pivot-Table-to-Excel-is-Formatted-as-Text/m-p/1520781#M37283 bcr123psu 2018-12-14T00:18:33Z https://community.qlik.com/t5/App-Development/Exporting-Pivot-Table-to-Excel-is-Formatted-as-Text/m-p/1520789#M37285 <P>can you provide more details or sample qvf as it is not easy to be reproduced.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/2184i73A8967A4F0D7CF6/image-size/medium?v=v2&amp;px=400" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>&nbsp;</P><P>ZZ</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 14 Dec 2018 02:43:27 GMT https://community.qlik.com/t5/App-Development/Exporting-Pivot-Table-to-Excel-is-Formatted-as-Text/m-p/1520789#M37285 zzyjordan 2018-12-14T02:43:27Z