How to display top 5 sales person name in Qlikview Dashboard?

qlikview

#1

Hi,

I am creating a dashboard in Qlikview for automobile company. One of the requirement of business heads is they want to highlight the top and bottom 5 sales manager with their name and it must be dynamic as per current selection. Can you please help me to perform this?

Thanks,
Pankaj


#2

@pankajas_tanwar,

We can return top/ bottom names using functions AGGR() and Rank() and to combine all the names in single string use function concatenate with a separator.

One of the problem I have slved to show top products based on their sale is

=concat ( IF( aggr ( Rank(sum(Sale)),Product)<=2, Product & chr(10)))

For more detail on this you can follow this article:

Regards,
Sunil