topic Re: Export to Excel, column with wrong sign in QlikView

Export to Excel, column with wrong sign

danosoft — Tue, 17 Aug 2021 08:59:03 GMT

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

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):

QlikView (negative):

Re: Export to Excel, column with wrong sign

PrashantSangle — Tue, 17 Aug 2021 09:37:31 GMT

How's output of negative value in excel??

Re: Export to Excel, column with wrong sign

danosoft — Tue, 17 Aug 2021 09:46:40 GMT

with - in front of

Re: Export to Excel, column with wrong sign

stevejoyce — Tue, 17 Aug 2021 11:45:32 GMT

Use num() in your expression and put back to expression default.

Re: Export to Excel, column with wrong sign

danosoft — Tue, 17 Aug 2021 12:11:42 GMT

it is not an expression, it is not a chart, it is a table object, so I have only the name of the column

Re: Export to Excel, column with wrong sign

marcus_sommer — Tue, 17 Aug 2021 15:09:25 GMT

How does the values look like if you export the table into a csv-file and opening them with an editor like notepad++ ? If the brackets are there to show that's a negative value it means that Excel applies there own magic to interpret the content - in this case there won't be much possibilities to change the behaviour else it would be better to adjust the logic how negative values are shown.

- Marcus

Re: Export to Excel, column with wrong sign

danosoft — Tue, 17 Aug 2021 15:15:03 GMT

No, in the csv the values are always positive, so it is the export side from Qlik that does not take the negative value

Re: Export to Excel, column with wrong sign

marcus_sommer — Tue, 17 Aug 2021 15:29:17 GMT

What happens if you don't adjust the object-settings from the table-box else adjusting the number-format from this field within the document-settings?

- Marcus

Re: Export to Excel, column with wrong sign

danosoft — Tue, 17 Aug 2021 15:35:18 GMT

how can i change it there? I have to change the sign of this field only under certain conditions, i.e. inside a table that is displayed on a choice, and display it in the negative

Re: Export to Excel, column with wrong sign

marcus_sommer — Tue, 17 Aug 2021 15:39:44 GMT

A conditional adjustment isn't possible in this way but you may load this field twice - one for the normal displaying and the another for those special export-jobs.

- Marcus

Re: Export to Excel, column with wrong sign

danosoft — Tue, 17 Aug 2021 15:47:55 GMT

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

Re: Export to Excel, column with wrong sign

marcus_sommer — Tue, 17 Aug 2021 16:16:38 GMT

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