topic Re: Rank function in a block chart in QlikView

Rank function in a block chart

ericheleine — Mon, 23 Feb 2015 13:45:27 GMT

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?

Re: Rank function in a block chart

Anonymous — Mon, 23 Feb 2015 17:56:28 GMT

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

Re: Rank function in a block chart

ericheleine — Wed, 25 Feb 2015 09:45:50 GMT

thank you michael your answer has been heplfull