topic Simple export to excel in QlikView

Simple export to excel

Sun, 17 Jan 2010 21:55:32 GMT

I have not tried using the buttons with action items before so I tried exporting a pivot table to excel.

I created the attached test. When I press the XL in the caption it exports the table with the four expressions. However, when I use the button the file I get only shows the field the expression is based on not the four expressions.

Am I doing something wrong. How do I get round this so I can have a button that exports the table as I see it in qlikview.

Thanks

Simple export to excel

Sun, 17 Jan 2010 22:27:30 GMT

I used some code posted by FAA under the post

How do I create a VBscript to export data from a sheetobject to .CSV file

and it works.