Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
num(YourNumberField, '00')
num(YourNumberField, '00')
If your field containing the number is myField:
Num(myField,'00') will format the number as '01' instead of 1
hope it helps
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