QlikView Scripting

[#1]

Hello all,

I need you help with small problem.

I have excel like this:

A   B

1  150

1  150

1  150

1  150

1  250

1  168

1  75

My question is how do I select only the last value?

I need that in script, not in expressions

Thanks in advance

[ashfaq_haseeb · Accepted solution]

You need to look at peek function.

Regards

ASHFAQ

[ecolomer]

You can put an counter, and use RecNo() function

[tresesco]

Table1:

Load *, RowNo() as RowNum from <>;

Let vMax=Peek('RowNum');

Noconcatenate

Final:

Load * Resident Table1 where RowNum=$(vMax);

Drop Table Table1;

[bwisenosimenkg]

Table1:
load * inline [

A,   B

1,  150

1,  150

1,  150

1,  150

1,  250

1,  168

1,  75

];

let vLastA = Peek('A', -1,'Table1');

let vLastB = Peek('B', -1,'Table1');

Table2:

load '$(vLastA)' as A, '$(vLastB)' as B autogenerate 1;

drop table Table2;

[sudeepkm]

Another way of getting the last record and keeping it in a variable.

tab:

load * Inline [

A,B

1,150

1,150

1,150

1,150

1,250

1,168

1,75];

let vLastRecords = Peek('B',NoOfRows('tab')-1,'tab'); // can have another variable for field A