I want to add row numbers to the beginning of the rows in the table.

[sevvalk]

I want to add row numbers to the beginning of the rows in the table. Rowno() doesn't work.

[Chanty4u]

Try this 

Load

    AutoNumber(FieldName) as RowNumber,

    YourOtherFields

From YourTable;

[sevvalk]

Is there a way to do this on the page?

[Gabbar]

Can you share a sample SS like what do you want and if you want it in script or chart?

[sevvalk]

i want it in chart

[Gabbar]

Like how, Rowno() Should work in charts, that why i asked for sample SS.

[anat]

Rowno() function will work in your case to generate numbers.

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inter....

if not share the sample how you are trying to generate row numbers ?

[Or]

RowNo() has some issues, particularly when 0/null values are suppressed.

Chart-level scripting actually has a rare use case here - I've used the below to generate accurate row numbers.

// Row Numbers: Requires a measure named Row with a starting value of 0 or null(), name can be adjusted
Let P = HCNoRows();
For J = 1 to P
Put Row(J) = J;
Next;

[hanna_choi]

Hello Sevvalk

We can use row number in the table using rowno().

Do you need the result as below capture?
But, rowno() can not display TOTAL.

if you need others, Could you give us the sample data?

Best Regard

hanna.choi

[sevvalk · Accepted solution]

rowno(total)