topic Re: Ranking over a dimension in QlikView

Ranking over a dimension

jolivares — Mon, 04 Apr 2016 02:48:02 GMT

Hi community... I have a question. I need to rank sales over a dimension, but I forgot something. Check this out.

The first picture is the sales for Mar/2016 and a Producto Ranking. The second one shows the same but over three month, having the criteria of ranking of sales of march. Until here, everything is good.

Now, if I add a ProdType dimension, the result is unexpected. Look...

The result must be: the top 5 product by ProdType, having march as the month for the ranking

I attached a QVW with sample data, in order you can see the problem. Something is missing, because if I choose one ProdType a get the desire result.

Thanks in advance for your help.

Re: Ranking over a dimension

ecolomer — Mon, 04 Apr 2016 03:23:09 GMT

See this example:

Re: Ranking over a dimension

jolivares — Mon, 04 Apr 2016 12:27:25 GMT

Thanks Enrique, I already try this kind of solution including make a straight table but I need that just the Prod in the ranking appear.

Thanks again.

Re: Ranking over a dimension

jolivares — Mon, 04 Apr 2016 19:38:08 GMT

Ok... I got it

Sum({<MonYear, Prod={"=Aggr(Rank(Sum({<MonYear={'$(=MaxString(MonYear))'}>} Sales)),ProdType,Prod)<=5"}>} Sales)

This expresion make the problem solve.