topic Re: Auto generate field in QlikView

Auto generate field

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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. ?

Anil_Babu_Samineni — Wed, 31 May 2017 07:09:11 GMT

Yes, You can

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

AutoGenerate 999;

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

daveamz — Wed, 31 May 2017 07:09:55 GMT

Hi,

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

Regards,

David

qlikview979 — Wed, 31 May 2017 07:48:38 GMT

Hi,

try like this

T1:

LOAD

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

AutoGenerate 999;