Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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