Cell Number / RowNo for respective value

[#1]

Hi ,

I have a column in my application(see below)

Example
1
3
4
1
3
6

When the user selects inputs from other columns(not displayed here); respective value from the column above is returned(in bold and underlined). I need to get the row no of that particular value, ideas? Thank you for your efforts and time. Best,

Nik

[Anonymous]

You could try using the RowNo() function in your load script.  See attached qvw.

[#3]

I have an Access database connected to QlikView. All my values are loaded/stored from the database. I use multiple select statements to get the column i desire. How would i include the RowNo() in this scenario?

Thanks for a quick response.

Best,

Nik

[Anonymous · Accepted solution]

With a preceding load, like in the qvw I attached earlier, as in add the bit below in red italics above your load from Access

load

  rowno() as RowNo ,

  *

;

LOAD Example

FROM

[https://community.qlik.com/thread/163021]

(html, codepage is 1252, embedded labels, table is @1);

If you search this forum for Preceding Load you should find more info on it.

[#5]

Thanks Bill, appreciate the time and help.

Best,

Nik