Hi
I have a sql query that is returns records for a field that has values with different decimal places.
| A | B | C |
D | AD | BD | 0.3 |
E | AE | BD | 0.45 |
F | AF | BF | 0.2 |
However, when I load this query into Qlikview, the same record returns with 2 decimal places.
| A | B | C |
D | AD | BD | 0.30 |
E | AE | BD | 0.45 |
F | AF | BF | 0.20 |
I have not added any number format function in my load script. So, do not know how this can happen.
I need column C to retain the same format. Please help