topic Re: Expression / Set Analysis in QlikView

Expression / Set Analysis

Fri, 21 Nov 2014 15:10:21 GMT

How can we write an expression to return the value of a field at row number 20?

Re: Expression / Set Analysis

Anonymous — Fri, 21 Nov 2014 15:11:11 GMT

Is Row Number a field in your data model or does this refer to a line in a chart?

Re: Re: Expression / Set Analysis

Fri, 21 Nov 2014 15:18:00 GMT

Field 1	Field 2
A	100
B	200
C	150
D	120

Row number is the line number of an excel sheet from which data is taken. For example, I want the value of "Field 2" at row number 3 which is "150"

Re: Expression / Set Analysis

Fri, 21 Nov 2014 15:23:23 GMT

Add this to your script:

rowno() as row,

Re: Expression / Set Analysis

Anonymous — Fri, 21 Nov 2014 15:24:14 GMT

I would add this to the load statement for this table from excel:

TableName:

Load

....

RowNo() as RowNum

....

;

SelectedRow:

Load

Resident TableName

where RowNum = 20;

You can then use any information from SelectedRow in your scripting. If you plan on using this in a chart in the document itself, I would recommend a Set Analysis expression:

sum({$<RowNum = {20}>}Field1)

Re: Expression / Set Analysis

maleksafa — Fri, 21 Nov 2014 15:24:57 GMT

you can add in your script while loading the data rowno() and then in your set analysis you can filter on that.

Re: Expression / Set Analysis

Fri, 21 Nov 2014 15:31:53 GMT

Hi,

Table:

Load *, rowno() as rownum

From Sample.xls;

Tab2:

Load *

resident Table where rownum=3;

(Or else)

Tab2:

Load *

resident Table where rownum>3 and rownum<4;

Drop table Table;

Re: Expression / Set Analysis

Anonymous — Fri, 21 Nov 2014 15:33:58 GMT

RowNo( )

Returns an integer for the position of the current row in the table QlikView

Re: Expression / Set Analysis

Anonymous — Tue, 25 Nov 2014 16:05:43 GMT

Nishant,

Given the number of nearly identical responses to mine, I would appreciate the points if this has solved your problem.

Many thanks,

Steve