topic Re: #### Changes to Money - why ? in QlikView https://community.qlik.com/t5/QlikView/Changes-to-Money-why/m-p/607166#M1104726 <HTML><HEAD></HEAD><BODY><P>damn...</P></BODY></HTML> Mon, 07 Apr 2014 17:26:50 GMT 2014-04-07T17:26:50Z #### Changes to Money - why ? https://community.qlik.com/t5/QlikView/Changes-to-Money-why/m-p/607163#M1104723 <HTML><HEAD></HEAD><BODY><P>In one simple straight table, I had the following columns - Country, Division, Sales(Amount). The first row is [blank],[blank], <STRONG>####</STRONG></P><P>When I changed the Number Format Settings (NFS) in Number tab of this chart to MONEY, the third column shows $25.50. Why does this happen ? Why does it not show the same value, when NFS is Expression Default or Number with 0 precision ?</P></BODY></HTML> Sun, 06 Apr 2014 23:13:17 GMT https://community.qlik.com/t5/QlikView/Changes-to-Money-why/m-p/607163#M1104723 2014-04-06T23:13:17Z Re: #### Changes to Money - why ? https://community.qlik.com/t5/QlikView/Changes-to-Money-why/m-p/607164#M1104724 <HTML><HEAD></HEAD><BODY><P>one more thing. I loaded some more data into my qvw for another month (which comes from another file). then the $25.50 changes to ####. When I change money to Number, the #### changes to a number. What is happening and why ?</P></BODY></HTML> Sun, 06 Apr 2014 23:28:06 GMT https://community.qlik.com/t5/QlikView/Changes-to-Money-why/m-p/607164#M1104724 2014-04-06T23:28:06Z Re: #### Changes to Money - why ? https://community.qlik.com/t5/QlikView/Changes-to-Money-why/m-p/607165#M1104725 <HTML><HEAD></HEAD><BODY><P>The #### means there isn't enough room in the column to show the value.&nbsp; Expand the size of the column,&nbsp; and you should be able to see the value.</P></BODY></HTML> Mon, 07 Apr 2014 15:19:25 GMT https://community.qlik.com/t5/QlikView/Changes-to-Money-why/m-p/607165#M1104725 Nicole-Smith 2014-04-07T15:19:25Z Re: #### Changes to Money - why ? https://community.qlik.com/t5/QlikView/Changes-to-Money-why/m-p/607166#M1104726 <HTML><HEAD></HEAD><BODY><P>damn...</P></BODY></HTML> Mon, 07 Apr 2014 17:26:50 GMT https://community.qlik.com/t5/QlikView/Changes-to-Money-why/m-p/607166#M1104726 2014-04-07T17:26:50Z