Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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