QlikView App Dev

[#1]

In one simple straight table, I had the following columns - Country, Division, Sales(Amount). The first row is [blank],[blank], ####

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 ?

[#2]

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 ?

[Nicole-Smith · Accepted solution]

The #### means there isn't enough room in the column to show the value.  Expand the size of the column,  and you should be able to see the value.

[#4]

damn...