topic Re: Cell Number / RowNo for respective value in QlikView

Cell Number / RowNo for respective value

Wed, 06 May 2015 16:52:18 GMT

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

Re: Cell Number / RowNo for respective value

Anonymous — Wed, 06 May 2015 16:57:51 GMT

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

Re: Cell Number / RowNo for respective value

Wed, 06 May 2015 17:01:14 GMT

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

Re: Cell Number / RowNo for respective value

Anonymous — Wed, 06 May 2015 17:09:30 GMT

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.

Re: Cell Number / RowNo for respective value

Wed, 06 May 2015 17:14:49 GMT

Thanks Bill, appreciate the time and help.

Best,

Nik