https://community.qlik.com/t5/QlikView/Excel-Export-with-specific-format/m-p/1898500#M1217648 <P>Hello,<BR />Im trying to export a pivot table to excel using a macro,which is succesfully exported.<BR />1.How can we calculate the mean and SD as shown in image while exporting in qlikview itself?<BR />2.How can I export with the background colors like shown below fig 2?<BR />3.The description is not a field that is available in qvw,so how can we add that row?<BR />4.Also the index for reference(colour and its meaning)?<BR />Now when I export I get the data as shown:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Athira_K_1-1646105456438.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/73236i09652BF18E95C046/image-size/medium?v=v2&amp;px=400" role="button" title="Athira_K_1-1646105456438.png" alt="Athira_K_1-1646105456438.png" /></span></P> <P>&nbsp;</P> <P>My requirement is to export it in the image shown below:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Athira_K_0-1646104761139.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/73235iB287BEEF0F3F2325/image-size/medium?v=v2&amp;px=400" role="button" title="Athira_K_0-1646104761139.png" alt="Athira_K_0-1646104761139.png" /></span></P> <P><BR />How can we implement it?<BR />Thank you</P> <P>&nbsp;</P> Tue, 01 Mar 2022 06:19:52 GMT Athira_K 2022-03-01T06:19:52Z https://community.qlik.com/t5/QlikView/Excel-Export-with-specific-format/m-p/1898500#M1217648 <P>Hello,<BR />Im trying to export a pivot table to excel using a macro,which is succesfully exported.<BR />1.How can we calculate the mean and SD as shown in image while exporting in qlikview itself?<BR />2.How can I export with the background colors like shown below fig 2?<BR />3.The description is not a field that is available in qvw,so how can we add that row?<BR />4.Also the index for reference(colour and its meaning)?<BR />Now when I export I get the data as shown:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Athira_K_1-1646105456438.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/73236i09652BF18E95C046/image-size/medium?v=v2&amp;px=400" role="button" title="Athira_K_1-1646105456438.png" alt="Athira_K_1-1646105456438.png" /></span></P> <P>&nbsp;</P> <P>My requirement is to export it in the image shown below:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Athira_K_0-1646104761139.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/73235iB287BEEF0F3F2325/image-size/medium?v=v2&amp;px=400" role="button" title="Athira_K_0-1646104761139.png" alt="Athira_K_0-1646104761139.png" /></span></P> <P><BR />How can we implement it?<BR />Thank you</P> <P>&nbsp;</P> Tue, 01 Mar 2022 06:19:52 GMT https://community.qlik.com/t5/QlikView/Excel-Export-with-specific-format/m-p/1898500#M1217648 Athira_K 2022-03-01T06:19:52Z