Any one help me to find the nth row value from list of value ?

[#1]

Any one help me to find the nth row value from list of value ?

[Jason_Michaelides]

In your load script:

Load

   Date,

   StockQty,

   RowNo() AS RowNumber

From Excel...;

Then in your application create a text box with the expression:

=Only({<RowNumber={"Round(Max(RowNumber)*0.8)"}>} StockQty)

I may have the syntax slightly wrong (can't test right now) but this approach should work.

Hope this helps,

Jason

[#3]

Hello

Perhaps there is a better solution but the following expression will give you the value u seek:

=FieldValue('Stock Qty',round(count([Stock Qty])*0.8)-(count([Stock Qty]) -FieldValueCount('Stock Qty')))

the part after the minus sign is to adjust the rownr due to Qlikview counting two rows with the same value as one. Of course, count(distinct [Stock Qty]) would work but its not recommended to use count(distinct).

Hope this is what u were looking for.

Regards

Jonas

[#4]

thanks

I Used this script thorugh this script i can find the rownumber, but i need the value of that particular rownumber

='Pareto       ' &  round(count(AGGR(SUM(STOCK),STSTOCKDATE))*0.8)

[Jason_Michaelides]

Try

=Only({<RowNumber={"round(count(AGGR(SUM(STOCK),STSTOCKDATE))*0.8)"}>} StockQty)