Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I used some code posted by FAA under the post
and it works.