Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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

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;