Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
emmanueld
Partner - Creator
Partner - Creator

Hide invisible expressions from export

Hello,

I have a bar chart with a few expressions in it, and some are checked "invisible" and "text as popup" in order to see them in the hover-over box.

When I export my chart to excel, the "invisible" expressions are exported too as columns, but I don't want them. Is it possible not to export them?

Please see attached image if it helps

Thank you!

3 Replies
emmanueld
Partner - Creator
Partner - Creator
Author

Here, vPN_NextMilestoneDevelopment is the expression of my bar chart, and the hover-over shows "Duration : x days" which is the thing I don't want to show in my excel. Actually I would love to have just the x exported so I was counting on disabling the export of that expression from the excel and add another one giving only x.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Unfortunately, the hidden columns always show up in the export.  A workaround is to create an additional chart that contains just the columns you want to export. That chart can be minimized and users right-click-send to Excel. Another approach is to hide this second chart and export to xls using a macro with "ServerSideExportEx'. You can trigger the macro with a button placed on top of the main chart.

set tb = ActiveDocument.GetSheetObject("CH01")

tb.ServerSideExportEx "C:\test.xls" , ";" , 5

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

emmanueld
Partner - Creator
Partner - Creator
Author

I'm quite late for a response, but thanks a lot Rob for your answer

Emmanuel