Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
mauvasco62
New Contributor III

Autonumber or anything else

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

KeyInvoiceInvoice rowother dimensionvalue
15001bla bla bla1500
15002dddddd1200
15012ddddffff1250
15013yeerfs512

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

1 Solution

Accepted Solutions

Re: Autonumber or anything else

Is Invoice row what you are trying to achieve?

View solution in original post

4 Replies

Re: Autonumber or anything else

Is Invoice row what you are trying to achieve?

View solution in original post

mauvasco62
New Contributor III

Re: Autonumber or anything else

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

Mauro

Re: Autonumber or anything else

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

Capture.PNG

Try this

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

mauvasco62
New Contributor III

Re: Autonumber or anything else

Great!! Thank you!

Have a nice day

Mauro