https://community.qlik.com/t5/QlikView/Number-formatting/m-p/215630#M69046 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>When initially setting up our QlikView application we imported a field that was a calculation preformed on 2 numbers, unfortunately we did not specify the number of decimal places, our database defaults to 8. The QlikView application has only need for 2 decimal places, this has been fixed moving forward but my questions are</P><P class="MsoListParagraphCxSpFirst" style="text-indent: -18pt; margin: 0cm 0cm 0pt 36pt; mso-list: l0 level1 lfo1;">1. Will this have a effect on performance ? ( I really hope not since it was my mistake !!)</P><P class="MsoListParagraphCxSpMiddle" style="text-indent: -18pt; margin: 0cm 0cm 0pt 36pt; mso-list: l0 level1 lfo1;">2. Will changing the format in the preference sheet help ?</P><P class="MsoListParagraphCxSpLast" style="text-indent: -18pt; margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1;">3. If changing the preference does not help does anyone have any ideas how to change the existing QVD since it is not possible to recreate all the data ?</P><P>Thanks.</P></BODY></HTML> Wed, 14 Oct 2009 16:45:40 GMT 2009-10-14T16:45:40Z https://community.qlik.com/t5/QlikView/Number-formatting/m-p/215630#M69046 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>When initially setting up our QlikView application we imported a field that was a calculation preformed on 2 numbers, unfortunately we did not specify the number of decimal places, our database defaults to 8. The QlikView application has only need for 2 decimal places, this has been fixed moving forward but my questions are</P><P class="MsoListParagraphCxSpFirst" style="text-indent: -18pt; margin: 0cm 0cm 0pt 36pt; mso-list: l0 level1 lfo1;">1. Will this have a effect on performance ? ( I really hope not since it was my mistake !!)</P><P class="MsoListParagraphCxSpMiddle" style="text-indent: -18pt; margin: 0cm 0cm 0pt 36pt; mso-list: l0 level1 lfo1;">2. Will changing the format in the preference sheet help ?</P><P class="MsoListParagraphCxSpLast" style="text-indent: -18pt; margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1;">3. If changing the preference does not help does anyone have any ideas how to change the existing QVD since it is not possible to recreate all the data ?</P><P>Thanks.</P></BODY></HTML> Wed, 14 Oct 2009 16:45:40 GMT https://community.qlik.com/t5/QlikView/Number-formatting/m-p/215630#M69046 2009-10-14T16:45:40Z https://community.qlik.com/t5/QlikView/Number-formatting/m-p/215631#M69047 <HTML><HEAD></HEAD><BODY><P>Never mind, have found the solution...</P><P></P><P>round( WSV , 0.00001 )</P><BR /><BR /></BODY></HTML> Wed, 14 Oct 2009 20:21:11 GMT https://community.qlik.com/t5/QlikView/Number-formatting/m-p/215631#M69047 2009-10-14T20:21:11Z