Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mauvasco62
New Contributor II

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
MVP
MVP

Re: Autonumber or anything else

Is Invoice row what you are trying to achieve?

4 Replies
MVP
MVP

Re: Autonumber or anything else

Is Invoice row what you are trying to achieve?

mauvasco62
New Contributor II

Re: Autonumber or anything else

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

Mauro

MVP
MVP

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 II

Re: Autonumber or anything else

Great!! Thank you!

Have a nice day

Mauro

Community Browser