topic Uploading CSV - Error with Negative Currency Values in App Development

Uploading CSV - Error with Negative Currency Values

joshdellapietro — Wed, 26 May 2021 22:40:56 GMT

Hello,

I uploaded a CSV file to my Qlik Sense using the data load editor and am experiencing issues with some of my numbers. See picture, Column Y uploads fine, but Column Z seems to be not counting any negative values formatted as a currency (example ($100.00) rather than -100). Unfortunately, the data set I am working with is too big to open and change the formatting... Please help!

Re: Uploading CSV - Error with Negative Currency Values

MayilVahanan — Thu, 27 May 2021 03:27:58 GMT

HI @joshdellapietro

Change your MoneyFormat like below

SET MoneyFormat='$#,##0.00;-$#,##0.00';

Re: Uploading CSV - Error with Negative Currency Values

joshdellapietro — Thu, 27 May 2021 11:18:41 GMT

It is already set to this as default.

Re: Uploading CSV - Error with Negative Currency Values

MayilVahanan — Fri, 28 May 2021 01:09:41 GMT

Hi @joshdellapietro

Can you send the sample file n qvf file to proceed further.

Re: Uploading CSV - Error with Negative Currency Values

joshdellapietro — Fri, 28 May 2021 13:17:15 GMT

Hi @MayilVahanan

Unfortunately I can't attach the QVF for confidentiality reasons, but I have attached screenshots of my data load editor sets as well as the how the data is shown in the CSV file.

Also - it is not just the cell with the negative value that is not being recognized, but also the entire row itself isn't being recognized when trying total up columns in Qlik Sense.