Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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