Excel export issue

[#1]

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]

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.

S.

[avinashelite]

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

[beck_bakytbek]

Hi Srivali,

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

QlikTip #32: Exporting multiple QV objects to a single Excel document

i hope that helps

beck

[#5]

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.

[#6]

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]

Hi,

Are those invisible expression required for any calculation???

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

Regards