topic Re: Re: Hiding a column on Excel export in QlikView

Hiding a column on Excel export

Sat, 07 Jun 2014 12:18:43 GMT

Hi all,

I have a hidden column in Pivot table

I did it with the help of a one time Macro.

But when i am exporting the data to excel, it is showing the hidden column in excel.

How can I avoid this on export?

Thnaking in advance for you help.

Re: Hiding a column on Excel export

Gysbert_Wassenaar — Sat, 07 Jun 2014 13:03:29 GMT

You cannot prevent it. You can remove the hidden column from the pivot table. Or you can remove the hidden column from the excel file in excel. If you're not using the ajax client you can try writing a macro that exports the pivot table to excel and then removes the column from the excel worksheet.

Re: Hiding a column on Excel export

IAMDV — Sat, 07 Jun 2014 13:42:18 GMT

Hi Keshav,

Why don't use calculation condition on the Expression/Dimension to hide/show the column in Pivot Table. And this way QlikView excludes the hidden column while exporting to Excel. Another advantage is that you don't have to use the Macro.

I hope this helps!

Cheers,

www.QlikShare.com

Re: Hiding a column on Excel export

Sun, 08 Jun 2014 05:46:00 GMT

Hi Deepak,

I have to hide the column because it is something not needed to show to the customer.

If I do not use that column in the grid, it will sum up the expression column and the customer will not be able

to see the individual entries.

So, I have to have that column in the grid for having individual entries.

Now in excel sheet, it is coming as a hidden column only, but the problem is that the number of excel sheet columns(as it starts A,B,...) is getting skipped because of this.

So the customer is getting to know about the hidden column.

That is why i want to hide it at the time of export to the excel.

Is there any way.

Thanks in advance.

Re: Hiding a column on Excel export

Sun, 08 Jun 2014 05:47:54 GMT

Hi Gysbert,

Thanks for you reply.

How can I override the export functionality of Pivot table.

Shall you provide some reference code for that.

Thanks for you help in advance.

Re: Re: Hiding a column on Excel export

IAMDV — Sun, 08 Jun 2014 10:30:34 GMT

I kind of get what you're trying to do. Can you post the sample QVW file? I'm sure there is way to sort this out in expressions/script without using the hiding approach.

Cheers,