Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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 ?

4 Replies
jason_michaelid
Honored Contributor II

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

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

Not applicable

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

Not applicable

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)

jason_michaelid
Honored Contributor II

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)

Community Browser