How to get current row number?

Tue, 04 Mar 2014 13:18:32 GMT

Hi,

i have following tables:

Table 1

Category Sub-Category Title FromCode ToCode

ABC xyz the title 0101 0101100

ABC xyz1 the title 0101 0101100

ABE xyz2 the title 0101 0101100

ABE xyz3 the title 0101 0101100

Table 2

Code Value

0101 110.00

0101100 200.00

What i want to do!

- read range from table 1

- sum Value falling in the range

Challenge

From/To Codes are character string. Therefore, using rangesum seems not to be working on it.

Solution in Mind

to be able to get row number (in table 2) for From/To Code by looking up in table 2. Once, i get the row number than i can apply following expression:

Sum({$<RowNo ={">=$(=FromRowNo)<$(=ToRowNo)"}>}Value)

Problem

How to get the row no as per the above solution that i have in mind?

Thanks in advance,

Sibtain

Re: How to get current row number?

alexandros17 — Tue, 04 Mar 2014 13:20:24 GMT

When you load tab2 add a field using autonumber (look in help)

Re: How to get current row number?

Tue, 04 Mar 2014 13:41:37 GMT

I want to be able to get row no by looking up the code in the table 2. so that i could use that row no in Rangesum function to get the desired value.

Sibtain

topic Re: How to get current row number? in QlikView

How to get current row number?

Re: How to get current row number?

Re: How to get current row number?