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?
