topic export to excel in QlikView https://community.qlik.com/t5/QlikView/export-to-excel/m-p/170456#M40879 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>How can i export some column of a pivot table to excel using a macro. I know how to export all object, but not some colomun.</P><P></P><P>Rgds.</P></BODY></HTML> Wed, 03 Nov 2010 16:05:53 GMT 2010-11-03T16:05:53Z export to excel https://community.qlik.com/t5/QlikView/export-to-excel/m-p/170456#M40879 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>How can i export some column of a pivot table to excel using a macro. I know how to export all object, but not some colomun.</P><P></P><P>Rgds.</P></BODY></HTML> Wed, 03 Nov 2010 16:05:53 GMT https://community.qlik.com/t5/QlikView/export-to-excel/m-p/170456#M40879 2010-11-03T16:05:53Z export to excel https://community.qlik.com/t5/QlikView/export-to-excel/m-p/170457#M40880 <HTML><HEAD></HEAD><BODY><P>I sort of cheat here by having a seperate (hidden) pivot table just containing the columns the user wants to export and then create an 'Export' button that runs a macro to export the hidden object. I often make the button 100% transparent and then place it on the original pivot table title.</P><P>Regards,</P><P>Gordon</P></BODY></HTML> Wed, 03 Nov 2010 16:26:24 GMT https://community.qlik.com/t5/QlikView/export-to-excel/m-p/170457#M40880 2010-11-03T16:26:24Z export to excel https://community.qlik.com/t5/QlikView/export-to-excel/m-p/170458#M40881 <HTML><HEAD></HEAD><BODY><P>I want to export some dimensions without expression? when i clone my chart and disable the expressions i loose all data!</P></BODY></HTML> Wed, 03 Nov 2010 16:37:01 GMT https://community.qlik.com/t5/QlikView/export-to-excel/m-p/170458#M40881 2010-11-03T16:37:01Z export to excel https://community.qlik.com/t5/QlikView/export-to-excel/m-p/170459#M40882 <HTML><HEAD></HEAD><BODY><P>I think i have just to use a table box which contain my dimension and hide it <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Wed, 03 Nov 2010 16:47:41 GMT https://community.qlik.com/t5/QlikView/export-to-excel/m-p/170459#M40882 2010-11-03T16:47:41Z