topic Re: Formatting numbered Dimensions in QlikView https://community.qlik.com/t5/QlikView/Formatting-numbered-Dimensions/m-p/696342#M1071198 <HTML><HEAD></HEAD><BODY><P>Hi David,</P><P></P><P>when working with calculated dimensions you will need to enclose your expression with Num</P><P></P><P>For instance : Num(Sum(Revenue), '#.##0,0000', '.', ',')</P><P></P><P>the last two parameters are decimal sep and thousand sep.</P><P></P><P>you absolutely need those when there is a difference between the ones in your format string, and the ones defined at the beginning of your script.</P><P></P><P>Loic</P></BODY></HTML> Mon, 18 Aug 2014 13:02:06 GMT lft 2014-08-18T13:02:06Z Formatting numbered Dimensions https://community.qlik.com/t5/QlikView/Formatting-numbered-Dimensions/m-p/696341#M1071197 <HTML><HEAD></HEAD><BODY><P><BR />Hi, I am using a straight table, and while I have the ability to formate expressions, I dont have the ability to format dimensions. At least, I dont see a way. And I have a caclulated dimension where I want the end result to be set to 4 decimal places. So 0.0000. Is there a way to do this in the editor? Maybe wrap around some format setting around my formula?</P><P></P><P>Thanks</P></BODY></HTML> Mon, 18 Aug 2014 12:56:26 GMT https://community.qlik.com/t5/QlikView/Formatting-numbered-Dimensions/m-p/696341#M1071197 2014-08-18T12:56:26Z Re: Formatting numbered Dimensions https://community.qlik.com/t5/QlikView/Formatting-numbered-Dimensions/m-p/696342#M1071198 <HTML><HEAD></HEAD><BODY><P>Hi David,</P><P></P><P>when working with calculated dimensions you will need to enclose your expression with Num</P><P></P><P>For instance : Num(Sum(Revenue), '#.##0,0000', '.', ',')</P><P></P><P>the last two parameters are decimal sep and thousand sep.</P><P></P><P>you absolutely need those when there is a difference between the ones in your format string, and the ones defined at the beginning of your script.</P><P></P><P>Loic</P></BODY></HTML> Mon, 18 Aug 2014 13:02:06 GMT https://community.qlik.com/t5/QlikView/Formatting-numbered-Dimensions/m-p/696342#M1071198 lft 2014-08-18T13:02:06Z Re: Formatting numbered Dimensions https://community.qlik.com/t5/QlikView/Formatting-numbered-Dimensions/m-p/696343#M1071199 <HTML><HEAD></HEAD><BODY><P>Many thanks!</P></BODY></HTML> Mon, 18 Aug 2014 13:22:32 GMT https://community.qlik.com/t5/QlikView/Formatting-numbered-Dimensions/m-p/696343#M1071199 2014-08-18T13:22:32Z