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

[vupen · Accepted solution]

You can use the built in QV function - RecNo( ). It gives the Record Number, which is sequential.

Ex:

Load
<h4>RecNo( ) as SNo,</h4>
Name,
Address
;
SQL SELECT
Name,
Address
From TABLE_NAME
;

[pover]

Hi Frenky,

I'm not sure exactly what you're looking for, but if you want to create a column like 'No' then you can used the RowNo() function.

Note that the RecNo() function may not necessarily be conscutive because RecNo() will return the row number the record was found in the original database.

For example:

Original Table:

Name, City
James, London
Erik, Lund
Alice, London

Script:

Load RowNo() as No_1,
RecNo() as No_2,
Name,
City
From 'Orginal Table'
Where City = 'London'

Result:
1, 1, James, London
2, 3, Alice, London

I hope that's clear.

If you want to find the total number found, why don't you use count(distinct Name)?

Regards.

[d_pranskus]

Hi

See example attached

Cheers

Darius

[#5]

hi,

you can use

load rowno() as no or load recno() as no from ......... as suggested by upendra in your script

and for total found you can use

let total found =noofrows('tablename');

thanks

[#6]

Hi guys,
Thank you all for replying my question.Formula approach for "rowno()" by tauqueer almost hit my question. (image1 below) BUT when I do a filter is doesn't do correctly (image2 below).
Instead showing the perspective number of user, which this not required because I already have EE (employee number).
Basically i want is to find how many total the result of employee if I do a filter.
And I still confuse how to create TOTAL FOUND.

[#7]

hi,

you can use

getpossiblecount(Employeename) to know how many employees have been terminated(ie no of employees in the current selection)

and getexcludedcount(Employeename) to know how many employees have been excluded from the current selection

as expressions in your straight table

thanks

[#8]

Dear Tauqueer,
i'm not sure the formula where can i put in. it become like these below

[bismart]

Just create counter field with value of 1 and use sum(counterField) in your expressions...

Load

1 as CounterField,

Name,

Address

;

SQL SELECT

Name,

Address

From TABLE_NAME

;

[#10]

Hi Karl & all,
Thanks replying my question.
It seem both rowno() and recno() has same function, and this is close formula.
Basicly what i want is just running number, l those like in excel.
But i do not want the running number taken from database.
I tried both give the result same when do a filter the running number become number from database, which we not it that.
for the total number found it seem give me different result when i do fiter, please check my screen shoot on No_1[rowno()] and No_2 [recno()]

Anyway for total found using count(No_1) or count(No_2) it seem was the correct formula to get how many the result.

Can anyone help me on this?