Qlik Community

Ask a Question

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
g_kolkman
Contributor
Contributor

Qlikview Macro Export Excel

Hi all,

Currently I'm generating a report for a company out of qlikview. We use macro's to generate an excel file which is then exported to pdf. The macro's were created in Qlik 11. In Q11 the total column was exported based on the settings of the graph (bottom or top), however in Q12 the totals of a straight table are always exported on top. 

Is there a setting i'm missing or is this just how Q12 handles exporting straight tables. I can of course manually handle this but I'd prefer if Qlik just adopts my graph setting.

Thanks in advance.

Labels (4)
1 Reply
Brett_Bleess
Support (Former)
Support (Former)

Gerben, it would be most helpful if you can attach a QVW with the macro code and the sheet object, so folks can have a look at the properties etc.  My best hunch would be to check your Straight Table object properties, in particular the Presentation tab settings, I am placing an image below for you, as I think this is the likely issue, but if not, please see if you can attach things.

StraightTableProperties.png

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.