Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pauljohansson
Creator III
Creator III

Question regarding Num function

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand