Need bottom 20 results

[MIKIEMILLER]

I have an expression:

Sum([Net Cash])

I need to only show the lowest 20 results of this expression in a table based on the dimension [ID].  I tried this expression, but it brought in the lowest 20 IDs.  I want it to sort by ID based on the 20 lowest Net Cash values.

if(aggr(rank(Sum([Net Cash])),[ID])<=20,[ID])

[isingh30]

Did you call stored procedures ?

How to Call stored procedure in Qlikview

Thanks.

[MIKIEMILLER]

Here is an excel sheet with the exported data from qlik for that table.

[dan_sullivan]

Can't you use the built in functionality of the table dimension to just set the limit to return bottom 20?

[MIKIEMILLER]

Dan,

That does not work because on any given day, some IDs might not have any data, so that just gives me either no data selected or zero values. This is what happens when I say to put a fixed limitation on the bottom 20.

[dan_sullivan]

can you uncheck the "include null values" and in your data script set the 0's to be null?

[MIKIEMILLER]

They are unchecked.