Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
g_kolkman
Contributor
Contributor
‎2019-10-21 05:39 AM

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)
Labels
653 Views
0 Likes
1 Solution

Accepted Solutions
Brett_Bleess
Former Employee
Former Employee
‎2019-10-30 10:49 AM

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.

View solution in original post

614 Views
0 Likes
1 Reply
Brett_Bleess
Former Employee
Former Employee
‎2019-10-30 10:49 AM

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.
615 Views
0 Likes