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: 
Not applicable

Number Formatting

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.

1 Solution

Accepted Solutions
Nicole-Smith

num(YourNumberField, '00')

View solution in original post

3 Replies
Nicole-Smith

num(YourNumberField, '00')

alexandros17
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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