topic Re: Error in num() formating? in QlikView https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536102#M200339 <HTML><HEAD></HEAD><BODY><P>Press F1, help, seach index for "Format codes".&nbsp;&nbsp; The problem is that num() doesn't behave accordingly.</P></BODY></HTML> Wed, 28 Aug 2013 13:37:36 GMT johanfo2 2013-08-28T13:37:36Z Error in num() formating? https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536098#M200335 <HTML><HEAD></HEAD><BODY><P>This statement:</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp; num('0,1', '#,00##') as TEST,</P><P>...</P><P></P><P>returns</P><P>0,1000</P><P>but I expect</P><P>0,10</P><P></P><P>I'm on a European system with decimal separator as ',', but I belive this problem is identical on US setup.</P><P>According to the documentation, I quote:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 0.000 describes the number with three decimals. </P><P>&nbsp;&nbsp;&nbsp;&nbsp; 0.0## describes the number with at least 1 decimal and at most three decimals.</P><P></P><P>Can anybody confirm this apparent bug?</P><P></P><P>JF</P></BODY></HTML> Tue, 27 Aug 2013 13:17:51 GMT https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536098#M200335 johanfo2 2013-08-27T13:17:51Z Re: Error in num() formating? https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536099#M200336 <HTML><HEAD></HEAD><BODY><P>'0,1' is a string and can't not formatted with num() - here you needed num(num#()). Also num() had further parameter which could defined the decimal separator, independent from system settings - see this and examples by F1.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 27 Aug 2013 13:29:35 GMT https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536099#M200336 marcus_sommer 2013-08-27T13:29:35Z Re: Error in num() formating? https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536100#M200337 <HTML><HEAD></HEAD><BODY><P>Hi JF,</P><P></P><P>which documentation do you refer to? I think there are only fixed decimals possible: '#0,00'</P><P></P><P>- Ralf</P></BODY></HTML> Tue, 27 Aug 2013 13:29:54 GMT https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536100#M200337 rbecher 2013-08-27T13:29:54Z Re: Error in num() formating? https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536101#M200338 <HTML><HEAD></HEAD><BODY><P>No, it does format the number. And further, changing '0,1' to 0.1 does not change the result.</P><P>The problem is that the documentation regarding num() refers to "format codes".&nbsp; If you search the index in the help (F1) for "format codes", you find the text I'm quoting above.</P></BODY></HTML> Wed, 28 Aug 2013 13:35:26 GMT https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536101#M200338 johanfo2 2013-08-28T13:35:26Z Re: Error in num() formating? https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536102#M200339 <HTML><HEAD></HEAD><BODY><P>Press F1, help, seach index for "Format codes".&nbsp;&nbsp; The problem is that num() doesn't behave accordingly.</P></BODY></HTML> Wed, 28 Aug 2013 13:37:36 GMT https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536102#M200339 johanfo2 2013-08-28T13:37:36Z Re: Error in num() formating? https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536103#M200340 <HTML><HEAD></HEAD><BODY><P>Right. Must be a bug or a wrong format code example then..</P></BODY></HTML> Wed, 28 Aug 2013 13:44:14 GMT https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536103#M200340 rbecher 2013-08-28T13:44:14Z Re: Error in num() formating? https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536104#M200341 <HTML><HEAD></HEAD><BODY><P>Surprisingly hard to find a place to submit this bug?</P><P></P><P>Do Qliktech have a bug submit form?</P></BODY></HTML> Thu, 29 Aug 2013 11:30:40 GMT https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536104#M200341 johanfo2 2013-08-29T11:30:40Z Re: Error in num() formating? https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536105#M200342 <HTML><HEAD></HEAD><BODY><P>They have a form to submit support cases in the Qonnect Partner Portal, see link below.</P><P></P><P>Maybe it's also good to move this thread into the QlikBug group..</P></BODY></HTML> Thu, 29 Aug 2013 12:08:58 GMT https://community.qlik.com/t5/QlikView/Error-in-num-formating/m-p/536105#M200342 rbecher 2013-08-29T12:08:58Z