Uploading CSV - Error with Negative Currency Value... - Qlik Community

joshdellapietro · ‎2021-05-26

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 · ‎2021-05-26

HI @joshdellapietro

Change your MoneyFormat like below

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

joshdellapietro · ‎2021-05-27

It is already set to this as default.

MayilVahanan · ‎2021-05-27

Hi @joshdellapietro

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

joshdellapietro · ‎2021-05-28

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.

Uploading CSV - Error with Negative Currency Values