topic Re: calculate daily rank in QlikView

calculate daily rank

mattheomx — Thu, 05 Mar 2015 21:30:55 GMT

I have the following scenario: user selected a Milk from Product selection box.

The requirement is to display the daily ranking based on Sales for the last couple couple of days for product Milk. The resulting table should look like this:

Date	Rank
3/3/2015	5
3/4/2015	2
3/5/2015	4
3/6/2015	4
3/7/2015	6
3/8/2015	4

How can this be achieved?

Re: calculate daily rank

chrislofthouse — Fri, 06 Mar 2015 09:45:44 GMT

See the application ! ! attached.

Re: calculate daily rank

mattheomx — Fri, 06 Mar 2015 15:14:14 GMT

Thanks for the help but this solution doesn't work.

I reloaded the app with a different number to differentiate the sales. For 08/03 and 07/03 it works correctly. 06/03 and before have incorrect ranks:

Re: calculate daily rank

chrislofthouse — Fri, 06 Mar 2015 15:35:26 GMT

Is this any better?

Re: calculate daily rank

mattheomx — Fri, 06 Mar 2015 15:46:01 GMT

Here's a catch: when I select milk rank changes to 1:

The rank should stay as if there was no product selection. We should see rank 1 and rank 2 depending of the day.

Really appreciate the help!

Re: calculate daily rank

chrislofthouse — Fri, 06 Mar 2015 15:48:39 GMT

Ah sorry, I misunderstood your requirements:

Re: calculate daily rank

mattheomx — Fri, 06 Mar 2015 15:58:12 GMT

Great thank you!