topic Rank not calculated with TOTAL and aggr function in QlikView

Rank not calculated with TOTAL and aggr function

hugmarcel — Mon, 27 Feb 2012 08:24:21 GMT

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

Rank not calculated with TOTAL and aggr function

jagan — Mon, 27 Feb 2012 08:30:33 GMT

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.

Rank not calculated with TOTAL and aggr function

hugmarcel — Mon, 27 Feb 2012 10:02:24 GMT

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

Re: Rank not calculated with TOTAL and aggr function

qlikviewajeet — Mon, 27 Feb 2012 10:11:24 GMT

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.

Re: Rank not calculated with TOTAL and aggr function

hugmarcel — Mon, 27 Feb 2012 10:17:37 GMT

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.

Re: Rank not calculated with TOTAL and aggr function

hugmarcel — Mon, 27 Feb 2012 12:30:14 GMT

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

See last example