topic Format Issues with Numbers in QlikView

Format Issues with Numbers

Thu, 30 Oct 2014 09:26:35 GMT

I got a very basic question but cannot make it work

Got two tables I want to joint

In both I have "Invoice Amount" but Table A : Comes from a systems and Values are like “-411,35” while fromm system B Values are like “411.35”

What is the script to make 411.35 be “-411,35”

Re: Format Issues with Numbers

anbu1984 — Thu, 30 Oct 2014 09:32:14 GMT

Replace(Replace(InvoiceAmt,'-',''),',','.')

Re: Format Issues with Numbers

Thu, 30 Oct 2014 10:14:52 GMT

Amazing...Thanks a lot Anbun

Re: Format Issues with Numbers

suresh_rawat — Thu, 30 Oct 2014 10:17:50 GMT

Hi,

Use this Expression.

='-' & Replace(Value,'.',',')

It will work for you.

Regards

Suresh

Re: Format Issues with Numbers

anbu1984 — Thu, 30 Oct 2014 10:19:06 GMT

Please close the post, if your queries are answered

Re: Format Issues with Numbers

Thu, 30 Oct 2014 10:25:52 GMT

use

=replace(num('411.35','#,##0.00')*-1,'.',','):

or use just replace and then set the number format from the Number Tab in charts.

Re: Format Issues with Numbers

its_anandrjs — Thu, 30 Oct 2014 10:33:40 GMT

Try this way also

Load

FABS( InvoiceAmt ) AS InvoiceAmt

From Location;

Load

IF ( InvoiceAmt < 0, Num( InvoiceAmt * -1,'#,##0.00') ), Num( InvoiceAmt,'#,##0.00') ) AS InvoiceAmt

From Location;

Regards

Anand

Re: Format Issues with Numbers

Thu, 30 Oct 2014 10:41:25 GMT

I checked once again and it works only for Debit values i.e: 411.35 be “-411,35” but not when I got Credit Values

-411.35 be “411,35” so I need some kind of If Function as well

Re: Format Issues with Numbers

anbu1984 — Thu, 30 Oct 2014 10:48:25 GMT

Load If(InvoiceAmt Like '-*',Replace(Replace(InvoiceAmt,'-',''),',','.'),'-' & Replace(InvoiceAmt,',','.')) Inline [

InvoiceAmt

"-411,35"

"411,35" ];