Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Try this,
Num#(Sales_Amt,'#,##0.00')
Hope it helps
Hi,
Try this,
Num#(Sales_Amt,'#,##0.00')
Hope it helps
hi,
Did you try num(Fieldname,'#,##0')
Deepak
Hi Deepak!
Yes, I tried it before but at no success. Thanx for replying!
Yeap this worked!