Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Exporting to Excel issue

Hi,

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

Any idea on this?

13.PNG

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Re: Exporting to Excel issue

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.

View solution in original post

3 Replies
Highlighted
Master II
Master II

Re: Exporting to Excel issue

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

Highlighted
Not applicable

Re: Exporting to Excel issue

is that possible to change it qlikview while exporting.

Highlighted
Master II
Master II

Re: Exporting to Excel issue

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.

View solution in original post