topic Re: Prepend zeros to a column in a table box ? in QlikView

Prepend zeros to a column in a table box ?

Mon, 21 Apr 2014 19:27:45 GMT

Column Id has values like 7,8,9 etc. I want it to be displayed as 007,008,009. Please show me how to do it.

Thanks.

Mon, 21 Apr 2014 19:30:41 GMT

In your Number format, click Number and put 000 in the Format Pattern.

maxgro — Mon, 21 Apr 2014 19:32:17 GMT

in tab number

Format Pattern 000

its_anandrjs — Mon, 21 Apr 2014 19:37:16 GMT

For column Id you can write this way also

=Num(Id,'000')

maxgro — Mon, 21 Apr 2014 19:46:19 GMT

in script, in chart, but in table box???

its_anandrjs — Mon, 21 Apr 2014 19:53:04 GMT

For table box need to add a field in the load script like

Load

Id,

Num(Id,'000') as NumId

From Location;