Uploading CSV - Error with Negative Currency Values

[joshdellapietro]

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!

[MayilVahanan]

HI @joshdellapietro 

Change your MoneyFormat like below

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

[joshdellapietro]

It is already set to this as default.

[MayilVahanan]

Hi @joshdellapietro 

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

[joshdellapietro]

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.