topic Re: pivot Table export to excel in QlikView https://community.qlik.com/t5/QlikView/pivot-Table-export-to-excel/m-p/384426#M143589 <HTML><HEAD></HEAD><BODY><P>Same look and feel like qlikview pivot table as excel format(including </P><P>expand option)</P></BODY></HTML> Wed, 05 Sep 2012 13:07:29 GMT Anonymous 2012-09-05T13:07:29Z pivot Table export to excel https://community.qlik.com/t5/QlikView/pivot-Table-export-to-excel/m-p/384424#M143587 <HTML><HEAD></HEAD><BODY><P>pivot table export to excel expand option not working in excle</P></BODY></HTML> Wed, 05 Sep 2012 12:53:16 GMT https://community.qlik.com/t5/QlikView/pivot-Table-export-to-excel/m-p/384424#M143587 Anonymous 2012-09-05T12:53:16Z Re: pivot Table export to excel https://community.qlik.com/t5/QlikView/pivot-Table-export-to-excel/m-p/384425#M143588 <HTML><HEAD></HEAD><BODY><P>You need to expand the table fully before exporting to Excel. But the functions in QV to expand, drag&amp;drop dimensions etc. isn't supported in Excel. </P><P></P><P><BR />You can perhaps use the functions Pivot Table or Autofilter in Excel to create a "similar" enviroment</P></BODY></HTML> Wed, 05 Sep 2012 12:57:34 GMT https://community.qlik.com/t5/QlikView/pivot-Table-export-to-excel/m-p/384425#M143588 martinpedersen 2012-09-05T12:57:34Z Re: pivot Table export to excel https://community.qlik.com/t5/QlikView/pivot-Table-export-to-excel/m-p/384426#M143589 <HTML><HEAD></HEAD><BODY><P>Same look and feel like qlikview pivot table as excel format(including </P><P>expand option)</P></BODY></HTML> Wed, 05 Sep 2012 13:07:29 GMT https://community.qlik.com/t5/QlikView/pivot-Table-export-to-excel/m-p/384426#M143589 Anonymous 2012-09-05T13:07:29Z Re: pivot Table export to excel https://community.qlik.com/t5/QlikView/pivot-Table-export-to-excel/m-p/384427#M143590 <HTML><HEAD></HEAD><BODY><P>No but the Autofilter function in Excel, is quite simular to the expand option (but not so fancy) <A href="http://www.contextures.com/xlautofilter01.html">http://www.contextures.com/xlautofilter01.html</A> </P></BODY></HTML> Wed, 05 Sep 2012 13:10:07 GMT https://community.qlik.com/t5/QlikView/pivot-Table-export-to-excel/m-p/384427#M143590 martinpedersen 2012-09-05T13:10:07Z Re: pivot Table export to excel https://community.qlik.com/t5/QlikView/pivot-Table-export-to-excel/m-p/384428#M143591 <HTML><HEAD></HEAD><BODY><P>treeview is possible in Excel</P></BODY></HTML> Wed, 05 Sep 2012 13:19:40 GMT https://community.qlik.com/t5/QlikView/pivot-Table-export-to-excel/m-p/384428#M143591 Anonymous 2012-09-05T13:19:40Z