Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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