topic Re: CSV with Negative Value upload to Qlikview in QlikView

CSV with Negative Value upload to Qlikview

Thu, 30 Jan 2014 09:41:33 GMT

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.

Re: CSV with Negative Value upload to Qlikview

rustyfishbones — Thu, 30 Jan 2014 09:44:38 GMT

Can you share the CSV file?

Re: CSV with Negative Value upload to Qlikview

Thu, 30 Jan 2014 09:48:45 GMT

Attach your sample CSV...

Re: CSV with Negative Value upload to Qlikview

Thu, 30 Jan 2014 09:49:50 GMT

Hi,

You can load like this for example:

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

Hope this helps.

Re: CSV with Negative Value upload to Qlikview

Thu, 30 Jan 2014 09:59:51 GMT

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

Re: CSV with Negative Value upload to Qlikview

Thu, 30 Jan 2014 10:01:13 GMT

Dear Pierre de Calan

Thanks for your Response. Its working Perfectly.

Regards,

Sakthi