topic Number format different between SQL and Qlikview in QlikView https://community.qlik.com/t5/QlikView/Number-format-different-between-SQL-and-Qlikview/m-p/1084844#M361270 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a sql query that is returns records for a field that has values with different decimal places.</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">A</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">B</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">C</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AD</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BD</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0.3</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">E</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AE</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BD</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0.45</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">F</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AF</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BF</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0.2</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>However, when I load this query into Qlikview, the same record returns with 2 decimal places.</P><P></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">A</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">B</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">C</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AD</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BD</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0.30</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">E</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AE</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BD</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0.45</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">F</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AF</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BF</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0.20</SPAN></TD></TR></TBODY></TABLE><P></P><P>I have not added any number format function in my load script. So, do not know how this can happen.</P><P>I need column C to retain the same format. Please help</P></BODY></HTML> Tue, 09 Feb 2016 23:21:59 GMT ssha1983 2016-02-09T23:21:59Z Number format different between SQL and Qlikview https://community.qlik.com/t5/QlikView/Number-format-different-between-SQL-and-Qlikview/m-p/1084844#M361270 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a sql query that is returns records for a field that has values with different decimal places.</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">A</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">B</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">C</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AD</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BD</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0.3</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">E</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AE</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BD</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0.45</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">F</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AF</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BF</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0.2</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>However, when I load this query into Qlikview, the same record returns with 2 decimal places.</P><P></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">A</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">B</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">C</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">D</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AD</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BD</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0.30</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">E</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AE</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BD</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0.45</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">F</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AF</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BF</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0.20</SPAN></TD></TR></TBODY></TABLE><P></P><P>I have not added any number format function in my load script. So, do not know how this can happen.</P><P>I need column C to retain the same format. Please help</P></BODY></HTML> Tue, 09 Feb 2016 23:21:59 GMT https://community.qlik.com/t5/QlikView/Number-format-different-between-SQL-and-Qlikview/m-p/1084844#M361270 ssha1983 2016-02-09T23:21:59Z