Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ssha1983
Contributor II
Contributor II

Number format different between SQL and Qlikview

Hi

I have a sql query that is returns records for a field that has values with different decimal places.

   

ABC
DADBD0.3
EAEBD0.45
FAFBF0.2

However, when I load this query into Qlikview, the same record returns with 2 decimal places.

   

ABC
DADBD0.30
EAEBD0.45
FAFBF0.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

0 Replies