Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get the specified rownumber of a field in straight table

Hi All,

Please help me out in this scenario!

How to get the row number for specified filed from straight table .

for example

if name = James then  should return 2

 

id

Name

Address

56

steve

US

90

James

UK

81

Jack

IND

 

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

check sample example

inde.PNG

View solution in original post

7 Replies
Chanty4u
MVP
MVP

Hi,

Am not sure  . you can try field index function

adamdavi3s
Master
Master

just load rowno() and make life easier?

Chanty4u
MVP
MVP

sample :

           A) Field Index :

                                      Syntax:    fieldindex( fieldname, value )


  • Returns the position of the field value in the field fieldname (by loadorder). If value cannot be found among the field values of the field fieldname, 0 is returned. Fieldname must be given as a string value,

                                                      e.g. the field name must be enclosed by single quotes.

                                        This is like vLookup.

Example:

Table.PNGFrom this above table Field Index ,

  1. FieldIndex('Customer','Jenny'


Output:

FieldINDEx.PNG

Chanty4u
MVP
MVP

check sample example

inde.PNG

Not applicable
Author

Thanks !!

Chanty4u
MVP
MVP

welcome

trdandamudi
Master II
Master II

One more way you can do this is as below with a straight table:

RowNum_01.jpg

Expression for Row# is : =Aggr(RowNo(),id)