Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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

 

2 Replies
avinashelite
MVP
MVP

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