Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Need bottom 20 results

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])

Qlik Forums Bottom 20.GIF

15 Replies
Highlighted

May be try this

Aggr(If(Rank(-Sum([Net Cash])) < 21, [ID]), [ID])

Highlighted
Contributor III
Contributor III

Thanks Sunny but that still shows the value as the ID # not the Net Cash Value

Qlik Forums Bottom 20.1.GIF

Highlighted

May be try this

Aggr(If(Rank(-Sum([Net Cash])) < 21, Sum([Net Cash])), [ID])

Highlighted
Specialist
Specialist

May be this -

= only({<Net < {439}>}ID)

OR

= IF(Net < 439,'ID','Net')

Highlighted
Contributor III
Contributor III

Ishtdeep,

Thanks for the reply, but the data is always going to be updated.  So those values are only good as of today.  Tomorrow they will change.

Highlighted
Contributor III
Contributor III

Sunny,

Both expressions are giving me null answers when in actuality there sum(net cash)  is on the right.

Qlik Forums Bottom 20.2.GIF

Highlighted

Would you be able to attach your qvf file?

Highlighted
Contributor III
Contributor III

Unfortunately I cannot.

Highlighted

Mocked up data to show the issue?