topic Re: Question regarding Num function in QlikView

Question regarding Num function

pauljohansson — Sun, 09 Dec 2012 19:25:03 GMT

Hi,

I have a questions thats propably really simply - but i dont manage to get it right.

Im loading numbers ranging from 55326 to 16487100.

Now i simply want to interpret these to 553,26 and 164871,00 etc..

I guess I should use the Num function, but in the reference documentation examples i cant find any similar case.

Please advice,

br
Paul

Re: Question regarding Num function

Gysbert_Wassenaar — Sun, 09 Dec 2012 20:38:39 GMT

Check the settings for the thousands separator and the decimal separator first.

SET ThousandSep='.';

SET DecimalSep=',';

Next, is 553,26 the result of 55326 / 100? If so, you need to calculate that first: num(55326/100). You can specify a number format: num(55326/100,'#,##') to format it to show two decimals.