Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

Export to Excel, column with wrong sign

I have this problem, I have a table where I put negative value formatting like this:

danosoft_0-1629190532149.png

that is, it displays me the value with a negative sign if it is positive

When i export the table in excel, i see that field positive ... and instead i would like to see it negative like in the qlik view, is it possible?

Excel (positive):

danosoft_1-1629190665162.png

QlikView (negative):

danosoft_2-1629190780229.png

 

11 Replies
danosoft
Specialist
Specialist
Author

I had already thought of and implemented this solution, it was to understand if it could be done without having to create an extra field, and display it in the table

marcus_sommer

I'm not absolutely sure but I think Qlik doesn't export the rendered UI table else just fetched the appropriate data from the underlying virtual table. If it happens anywhere in this way you couldn't solve it directly else you need any workaround with additional efforts.

- Marcus