topic Re: Send table to Excel in QlikView

Send table to Excel

jjking58 — Wed, 25 Nov 2020 16:16:04 GMT

Can someone tell me if there is a way to send a table to excel with hidden columns. I know you can do it with a Macro, but that requires an IE plugin and can not be used with ajax. I would like to have something that works on Chrome or other browsers besides IE. Is it possible to use a jscript macro to achieve this?

I've search the community, but not been successful in finding a solution.

I'd appreciate any help or solutions

Jim

Re: Send table to Excel

MK9885 — Thu, 07 Dec 2017 13:56:38 GMT

Is there any condition to show/hide column?

If yes, then you can go to Settings>Presentation>Column Label>Conditional

This would satisfy and show column with your condition and export only available columns.

When you say send to XL with Hide Columns, you want to see the Hidden Column in XL but not in Qlik?

Re: Send table to Excel

jjking58 — Thu, 07 Dec 2017 15:09:53 GMT

Thanks S Khan for the reply, but i'm not sure i understand your suggestion.

The column is conditioned to always be hidden, but shown in excel.

What method is used to send the file and perform the show/hide of the column? A macro ?

Re: Send table to Excel

MK9885 — Thu, 07 Dec 2017 15:33:22 GMT

Yes a Macro can be used but I do not know which one.

The other workaround is not clean but it may just work for you?

To hide column from a table box

Check the reply from Sudeep Mahapatra from above link.

He basically suggest to have 2 tables for same chart overlaying each other.

The visible table would be chart with hidden column or you can eliminate the column. The below table would have all the columns.

You'd need to uncheck the 'Caption' option in settings for hidden table and make caption visible for hidden.

In this way when users click XL they sending report from back table which has all columns.

Also in Layout uncheck the Allow Move/size.. so that the tables won't move if the users tries to drag it

Of course this would be resource heavy as you'd be using 2 tables but wouldn't matter if the app size is less with less records.

Re: Send table to Excel

jjking58 — Thu, 07 Dec 2017 15:48:27 GMT

overlaying the tables seems to work. Great idea.

Thanks for all your help