Discussion board where members can get started with QlikView.
I want to QV to generate an ID field automatically. I am using the below function.
E' & AutoNumber(entity_name) as entity_id
This would generate E1, E2, E3,........, E999 etc.
Is there any way I can get these generated as E001,...........,E999 etc. ?
Go to Solution.
Yes. Use 'E' & Num(AutoNumber(entity_name), '000') as entity_id
Yes, You can
LOAD 'G' & AutoNumber(RowNo(),1000) as RowNo
Load 'G' & AutoNumber(RowNo(), entity_name) as entity_id
try like this
'E' & Num(AutoNumber(RecNo()), '000') as REC