Row number on table QlikSense

[joeybirdsx]

Hi - Using Qliksense

I wish to on the table chart create a row number column  

i want to create a row number in order of ID partition by order date 

How is this possible please something like

RowNo(ID,OrderDate)

reason why on table as i want count to reset based on filters on the sheet, and not use row number code in the data load

please help

[ajaykakkar93 · Accepted solution]

hi
just add RowNo(total) 
in measure

[joeybirdsx]

Hi

this gives a row number for every row, but i wish for it to look like 

RowNo       ID             Orderdate

1                   A123        01/05/2021

2                   A123        08/05/2021

1                  B568         06/05/2021

Please Advise 

[ajaykakkar93]

hi

data:
load Orderdate,ID,
AutoNumber(RowNo(),ID) as Row;
load * Inline [
ID,Orderdate
A123,01/09/2022
A123,04/09/2022
B568,04/09/2022
];

[joeybirdsx]

Hi, thanks for the reply, if i do the above in the data load, the row number will be fixed. I wish to do this please as a measure on the table object if possible. This is because the number of rows selected can change based on date filters. 

please advise 

[ajaykakkar93]

hi,

in that case

data:
load Orderdate,ID
load * Inline [
ID,Orderdate
A123,01/09/2022
A123,04/09/2022
B568,04/09/2022
];

just add both the dimension & add a measure rowno() as a measure u will get the same output

[joeybirdsx]

Hi

The row number does not change when i select the dates on the filter 

I wish it to re-organize the row count based on date filters 

how does the measure set anysis

as this does not work 

rowno(ID,OrderDate)  

please advise 

[ajaykakkar93]

Please look at attached hope it helps

[joeybirdsx]

Hi, i load data from SQL ..how can i change your inline code to work with an SQL data load please

please help

[Mendy]

Hi @joeybirdsx  were you able to solve this problem, if yes ,can you kindly share , how you were able to solve it.