Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

New Contributor

Format number correctly



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 Reply
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