Number Formatting

[#1]

This is probably easy/already been asked but what is an easy way to make a number appear as "01"? It is "01" in my source but Qlikview automatically changed it to "1"

Thanks in advance.

[Nicole-Smith · Accepted solution]

num(YourNumberField, '00')

[alexandros17]

If your field containing the number is myField:

Num(myField,'00') will format the number as '01' instead of 1

hope it helps

[Peter_Cammaert]

Two solutions:

In a chart, use the number tab and specify a custom format

For all other objects, you can use something like:

=num(YourNumber, '00')

Formatting always happens as the very last step