Discussion board where members can get started with Qlik Sense.
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
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
Is Invoice row what you are trying to achieve?
View solution in original post
Yes, i need to number the invoices row starting from 1 for every invoices
So, for 1501, you would want this, right?
AutoNumber(RowNo(), KeyInvoice) as [Invoice row]
Great!! Thank you!
Have a nice day