Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

top 100 of smallest amount

Hi guys!

I want to creat a table where it shows top 100 invoices with the smallest amount (but greater than 0).

Please help!

thank you!

//A.

3 Replies
Not applicable
Author

I need top 1000...

Not applicable
Author

Here would be my solution:

=IF(rank(IF(Amount>0,-Amount))<1000,Amount)


I don't know if you have to deal with sum of Amount.

Anonymous
Not applicable
Author

What if you just create a table without the 0-amounts,

Sort them on smallest amount first

Then set Max Number to 100 (presentation tab)