topic Re: Excel export issue in QlikView

Excel export issue

Thu, 04 Aug 2016 05:30:08 GMT

Hi,

I created a bar chart and made two expressions invisible. When I export it to excel, the invisible columns are also exported.

Is there any way to restrict invisible columns to be exported to excel.

Thanks in advance.

simospa — Thu, 04 Aug 2016 07:20:15 GMT

Hi,

do you need Invisible expressions because you are using them in the chart?

If you can disable them (unchecking Enable) they will not be visibile in Excel.

Let us know.

avinashelite — Thu, 04 Aug 2016 07:38:41 GMT

may i know how you have made them invisible ?? if its through cnditional statements then it woon't export for excel

beck_bakytbek — Thu, 04 Aug 2016 07:52:21 GMT

Hi Srivali,

check this: qlikblog.at. there you will fine enough Information to solve this issue:

i hope that helps

beck

Thu, 04 Aug 2016 08:40:12 GMT

Hi Simone,

I am using those invisible expressions in the chart. But when I export to excel I dont want those invisible expressions to be exported.

Thanks

Srivalli.

Thu, 04 Aug 2016 09:46:45 GMT

Hi Avinash,

For Bar chart expressions we have invisible check box that I have checked. So Its invisible in chart now.

But how to make them invisible in Excel while exporting?

PrashantSangle — Thu, 04 Aug 2016 10:22:57 GMT

Hi,

Are those invisible expression required for any calculation???

And How you made them invisible > in Display Option > Untick Bar????

Regards