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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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