topic Formatting as Numeric trouble in QlikView

Formatting as Numeric trouble

Wed, 04 Jul 2012 10:59:22 GMT

Hi all!

I am having an issue with forcing Qlikview to understand that Sales_Amt is numeric. The full numeric format of the document is #,##0.00. I tried to use evaluate() in conjuction with a multiplication with unity (1) to make it numeric and it worked fine with amount values that don't have the thousant separator as you can see in the following table excerpt.

Sales_Amt	Sales_Amt_Modiifed
	=evaluate(Sales_Amt & '*1')
string	number
151.86	151.86
2,789.57	-
2,790.0	-
3,511.92	-
33.27	33.27
71.1	71.1
76.8	76.8
86.35	86.35

Do you have any ideas on how to approach the solution to this?

Re: Formatting as Numeric trouble

MayilVahanan — Wed, 04 Jul 2012 11:03:47 GMT

Hi,

Try this,

Num#(Sales_Amt,'#,##0.00')

Hope it helps

Re: Formatting as Numeric trouble

deepakk — Wed, 04 Jul 2012 11:11:32 GMT

hi,

Did you try num(Fieldname,'#,##0')

Deepak

Re: Formatting as Numeric trouble

Wed, 04 Jul 2012 11:42:54 GMT

Hi Deepak!

Yes, I tried it before but at no success. Thanx for replying!

Re: Formatting as Numeric trouble

Wed, 04 Jul 2012 11:44:33 GMT

Yeap this worked!