topic Num Format in expression not working - model specific in QlikView https://community.qlik.com/t5/QlikView/Num-Format-in-expression-not-working-model-specific/m-p/151885#M29535 <HTML><HEAD></HEAD><BODY><P>I have a really strange (And frustrating) problem. In one model the following formula results in the sum of sales showing as <B>USD 2 344 232</B>, as an example.</P><P>=num(sum(Sales),'USD # ##0')</P><P>However, I am now working on another model - on the same laptop, same Qlikview etc. - and the format looks like this <B>USD</B> <B>2 344 232 ##0</B>. In fact I I can copy the object from the one model to the other and it will work in the one but not in the other.</P><P>It seems that in the one model, the format changes the number and in the new model I am working on the middle of the format is where the number goes and the USD and ##0 are just text that gets added to the front and the back.</P><P>Does anyone have any idea what the problem is? Is there a document setting that I am missing?</P><P>Thanks,</P><P>Steve</P><P></P><P></P></BODY></HTML> Fri, 06 Aug 2010 14:56:41 GMT wandapec 2010-08-06T14:56:41Z Num Format in expression not working - model specific https://community.qlik.com/t5/QlikView/Num-Format-in-expression-not-working-model-specific/m-p/151885#M29535 <HTML><HEAD></HEAD><BODY><P>I have a really strange (And frustrating) problem. In one model the following formula results in the sum of sales showing as <B>USD 2 344 232</B>, as an example.</P><P>=num(sum(Sales),'USD # ##0')</P><P>However, I am now working on another model - on the same laptop, same Qlikview etc. - and the format looks like this <B>USD</B> <B>2 344 232 ##0</B>. In fact I I can copy the object from the one model to the other and it will work in the one but not in the other.</P><P>It seems that in the one model, the format changes the number and in the new model I am working on the middle of the format is where the number goes and the USD and ##0 are just text that gets added to the front and the back.</P><P>Does anyone have any idea what the problem is? Is there a document setting that I am missing?</P><P>Thanks,</P><P>Steve</P><P></P><P></P></BODY></HTML> Fri, 06 Aug 2010 14:56:41 GMT https://community.qlik.com/t5/QlikView/Num-Format-in-expression-not-working-model-specific/m-p/151885#M29535 wandapec 2010-08-06T14:56:41Z Num Format in expression not working - model specific https://community.qlik.com/t5/QlikView/Num-Format-in-expression-not-working-model-specific/m-p/151886#M29536 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>the properties "number" are unchecked the parameter Override Document Settings?</P><P>Can you upload the qvw for more detail?</P><P></P></BODY></HTML> Fri, 06 Aug 2010 15:07:07 GMT https://community.qlik.com/t5/QlikView/Num-Format-in-expression-not-working-model-specific/m-p/151886#M29536 2010-08-06T15:07:07Z