Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formatting as Numeric trouble

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')
stringnumber
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?

1 Solution

Accepted Solutions
MayilVahanan

Hi,

     Try this,

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

     Hope it helps

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

View solution in original post

4 Replies
MayilVahanan

Hi,

     Try this,

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

     Hope it helps

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

hi,

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

Deepak

Not applicable
Author

Hi Deepak!

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

Not applicable
Author

Yeap this worked!