topic Re: Hide invisible expressions from export in QlikView

Hide invisible expressions from export

emmanueld — Tue, 29 Aug 2017 12:34:57 GMT

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!

Re: Hide invisible expressions from export

emmanueld — Tue, 29 Aug 2017 12:38:37 GMT

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.

Re: Hide invisible expressions from export

rwunderlich — Tue, 29 Aug 2017 17:04:35 GMT

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

Re: Hide invisible expressions from export

emmanueld — Thu, 01 Feb 2018 13:33:54 GMT

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

Emmanuel