Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Sra1bandi
Contributor II
Contributor II

How to add text and number zero's to ID number

Hi Team,

I have ID numbers

ID

1

2

4

5

4

6

7

.

.

10

.

.

2000

 

i want to show it as 

Before id i have to add Text as TNN00000

 

For example:-  ID 1 ====>  show as ====> TNN000001

                             ID 2 ==================> TNN000002

                             ID 10 =================> TNN000010

                             ID 111================> TNN000111

                            ID  1213================> TNN001213

 

IF the digits increased then we have to decrease the Zeros 

after TNN required six Numbers 

I have to show in ID value digit's increases then the zeros have to decreased as shown in the above example  

Thanks & Regards,

Sravan

 

Labels (1)
3 Replies
Lisa_P
Employee
Employee

Load using this:

'TNN'&Num(ID, '000000') as TNNID

vinieme12
Champion III
Champion III

you can take this  a step further 

Num(ID, 'TNN000000') 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Sra1bandi
Contributor II
Contributor II
Author

Thanks to both of you