Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Auto generate field

Hi,

I want to QV to generate an ID field automatically. I am using the below function.

E' & AutoNumber(entity_nameas entity_id

This would generate E1, E2, E3,........, E999 etc.

Is there any way I can get these generated as E001,...........,E999 etc. ?

1 Solution

Accepted Solutions
daveamz01
Creator III
Creator III

Hi,

Yes. Use 'E' & Num(AutoNumber(entity_name), '000') as entity_id

Regards,

David

View solution in original post

3 Replies
Anil_Babu_Samineni

Yes, You can

LOAD 'G' & AutoNumber(RowNo(),1000) as RowNo

AutoGenerate 999;


Or


Load 'G' & AutoNumber(RowNo(), entity_name) as entity_id

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
daveamz01
Creator III
Creator III

Hi,

Yes. Use 'E' & Num(AutoNumber(entity_name), '000') as entity_id

Regards,

David

View solution in original post

qlikview979
Specialist
Specialist

Hi,

try like this

T1:

LOAD

'E' & Num(AutoNumber(RecNo()), '000') as REC

AutoGenerate 999;