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

[marc_behrens]

Sorry for topic necromancy, but I was running into the same issue and RowNo() or RowNo(total) did not solve my issue as mentioned abobe. Losing sortability or showing too many rows.

I did try out these though:
https://community.qlik.com/t5/Design/Chart-Level-Scripting-Use-Cases-Samples-and-Examples/ba-p/19810... (see how to enable chart scripting if you don't know).

I simply added an expression which can actually have an empty expression at first position (-> measure.1).

After that added the following chart script:

Let P = HCNoRows();
For J = 1 to P
Put #hc1.measure.1(J) = J;
Next

It will set the value of the first expression cell to the current row no and seems to work fine even when sorting.

In my case, user wanted to have a leading rowno for exports, that will reflect his selection (so does not change).

Hope it helps 🙂