Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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
Contributor III

Re: Auto generate field

Hi,

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

Regards,

David

3 Replies
Highlighted

Re: Auto generate field

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
Contributor III

Re: Auto generate field

Hi,

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

Regards,

David

qlikview979
Valued Contributor

Re: Auto generate field

Hi,

try like this

T1:

LOAD

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

AutoGenerate 999;