Autonumber or anything else

[mauvasco62]

Hi all,

i'm new in Qlik sense and i need your support in order to solve a little (big) problem.

I have a table like this

KeyInvoice	Invoice row	other dimension	value
1500	1	bla bla bla	1500
1500	2	dddddd	1200
1501	2	ddddffff	1250
1501	3	yeerfs	512

I thought every line of invoice started from 1 but I found out that it was not.

I would therefore like to create a new field during the loading of the data that numbers the lines of each invoice. I would like to use the autonumber function but I'm not sure it works.

Do you have any suggestions to solve this problem?

Thanks in advance for your help

Mauro

[sunny_talwar · Accepted solution]

Is Invoice row what you are trying to achieve?

[mauvasco62]

Yes, i need to number the invoices row starting from 1 for every invoices

Mauro

[sunny_talwar]

So, for 1501, you would want this, right?

Try this

AutoNumber(RowNo(), KeyInvoice) as [Invoice row]

[mauvasco62]

Great!! Thank you!

Have a nice day

Mauro