Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Format number correctly

Hello,

 

i'm loading numbers from a file wich look like 0000000000999.

With the num() function i get the number 999, but i want to have 2 decimals like 9,99.

However everytime I try to format it like num(CollumName,'#.###,#0') it doesn't take the last 2 Numbers as decimals, qlikview adds 2 zero's and it looks like 999,00.

Does anyone know how to format the collum so that the last 2 numbers are the decimals?

Labels (3)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Format number correctly

Sure, divide the number by 100 then format the result to display two decimals.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: Format number correctly

Sure, divide the number by 100 then format the result to display two decimals.


talk is cheap, supply exceeds demand

View solution in original post