CSV with Negative Value upload to Qlikview

[#1]

Dear Folks,

             I have CSV file with Comma Separator.  If I load in Qlikview, the negative value is showing like 4.00- and it should be -4.00. Due to this i cant add that value. so total is showing wrongly. Please help ASAP.

Regards,

Sakthi.

[rustyfishbones]

Can you share the CSV file?

[#3]

Attach your sample CSV...

[#4 · Accepted solution]

Hi,

You can load like this for example:

if(Right(NumericField,1)='-',-1*Num#(Left(NumericField,Len(NumericField)-1),'#.#'),Num#(NumericField,'#.#'))

Hope this helps.

[#5]

Are the 4.00- in the CSV file ?

If yes, QlikView will able to read them. In the Table Viewer, you will see the data as they are in the file, but not in the UI (formatted as you want). You can also add or substract them.

If it still does not work, use the num() function. num(Yourfield, '#.##;#.##-', '.', '') as xx

Fabrice

[#6]

Dear Pierre de Calan

    Thanks for your Response. Its working Perfectly.

Regards,

Sakthi