Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Prepend zeros to a column in a table box ?

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.

1 Solution

Accepted Solutions
its_anandrjs

For column Id you can write this way also

=Num(Id,'000')

View solution in original post

5 Replies
Not applicable
Author

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

maxgro
MVP
MVP

in tab number

Format Pattern 000

its_anandrjs

For column Id you can write this way also

=Num(Id,'000')

View solution in original post

maxgro
MVP
MVP

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

its_anandrjs

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

Load

Id,

Num(Id,'000') as NumId

..

..

From Location;