Simple: How to get running numbers

[#1]

Dear All,
I new in qlikview programing, I have simple question, how do I get running number for the result and total found
Sample below:

No Name Address
1 John Doe Villa No.23
2 John Smith Ave No.32
3 James Smith Road No.2

Total found: 3

Thanks
Frenky

[pover]

Hi Frenky,

RecNo() and RowNo() will be different if you apply the filter in the script with a where statement. If you want dynamic row numbersin a table then you should use the rowno() function as an expression in the straight table.

See attached example.

Good luck

[#3]

Hi Karl,

Your sample fix my problem 🙂

But can wee use total found on the bottom of table? is should be easier to see if showing at below table

I no idea which table model should i use it.

[pover]

In the expression tab set the total mode as displayed in screenshot below for the column that has rowno().

Regards.

[pover]

And if you want the total to appear at the bottom of the table, that option is in the Presentation tab.

Regards.