Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
bhagi
Contributor II
Contributor II

values and percentage changes after export to excel

Hi Experts

I am facing problem with hours. Please check the highlighted column of snapshot.

The value changes after exporting.  why i am facing problem. Please suggest me how to reslove this

bhagi_0-1625816551784.jpeg

bhagi_1-1625816566380.jpeg

 

Labels (4)
2 Replies
avinashelite

I think this is know bug , you could resolve it by using the money() function don't use num() or the formatting option in the chart properties , this will solve yyour issue

Katiely6295
Contributor
Contributor

It appears that cell values are exported in native mode, which means that the percentage format is applied to the corresponding cell in MS Excel.

 

telldunkin