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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ericheleine
Contributor III
Contributor III

Rank function in a block chart

hi everyone,

I have an issue with the function Rank

My goal is to have the same block chart  below but only with the 5 first name sort by value

I selected 2 dimensions: Name & Factor

the formula is :

=aggr(sum([Value]), NAME,FACTOR)

When I use Rank I loose all my datas

Someone have an idea to resolve the pb?

2 Replies
Anonymous
Not applicable

Eric,

First, there is no such thing a s"sort" in the block chart.
Second, you probably do not need rank() function.  You can use "dimension" limit - show only largest five values.

Regards,
Michael

ericheleine
Contributor III
Contributor III
Author

thank you michael your answer has been heplfull