Rank not calculated with TOTAL and aggr function

[hugmarcel]

Hi, see example attached

I'd like to calculate the "over all weeks" rankings for product turnovers per employee. When I filter a specific week, then the value of the total ranking formula is not displayed any longer, if the product is not part of the filtered week.

The calculation should be done with the aggr-function.

Thank you for your help!

Marcel

[jagan]

Hi,

Use this expression to calculate Rank, there is no need to use AGGR()

= rank(sum({<WEEK=>} TURNOVER),0,0)

Hope this helps you.

Regards,

Jagan.

[hugmarcel]

I know it works without using the aggr function.

However, I NEED the aggr function, as I want the rank to be kept when I filter by employee.

We have found that the aggr function is needed in order to achieve this.

Marcel

[qlikviewajeet]

Hi,

We should use Straight Table to show Total, and i am agree with Jagan, here i don't think is need for Aggr(), if You think need, so i applied Aggr() in other table, plz go to Attachment. and let me know You got ur solution or not. let me know how i can help

You welcome.

[hugmarcel]

see my new example attached.

As said, the AGGR function is needed. Otherwise it is not possible to keep the ranking order when an employee is being filtered.

[hugmarcel]

It looks like the only solution to the problem is to add "artificial data" and later filter this out.

See last example