4 Replies Latest reply: May 15, 2012 5:13 AM by Jason Michaelides

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

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

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

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

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

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)

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

Try

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

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

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