Exporting to Excel issue

[#1]

Hi,

I am exporting a pivot chart to excel but i am getting an junk value as shown below.

Any idea on this?

[m_woolf]

It looks like a formatting issue in Excel. Select the column and change the format to General.

[#3]

is that possible to change it qlikview while exporting.

[m_woolf · Accepted solution]

Probably not.

I assume the problem field is a dimension in your chart. You can try to format the dimension something like:

=num(MyDim,'#,##0')

This may or may not help.