topic Re: Max percent of Top 5 differences as expression in QlikView

Max percent of Top 5 differences as expression

Wed, 22 Jul 2015 09:24:33 GMT

Hello,

I need a expression to calculate the max percent of the Top 5 differences.

So I found a solution to calculate the Top 5 differences, but not the max percent.

In the attached example, I have to calculate the 70%.

Re: Max percent of Top 5 differences as expression

Fri, 24 Jul 2015 22:05:58 GMT

Did anybody knows a solution?

Re: Max percent of Top 5 differences as expression

sunny_talwar — Sat, 25 Jul 2015 03:16:58 GMT

May be this in a text box object:

=Num(Aggr(If(Rank(Sum({<Year = {2015}>} Sales) - Sum({<Year = {2014}>} Sales), 0, 1) = 3, (Sum({<Year = {2015}>} Sales)-Sum({<Year = {2014}>} Sales))/Sum({<Year = {2014}>} Sales)), Dim), '##%')

Re: Max percent of Top 5 differences as expression

Tue, 04 Aug 2015 08:48:20 GMT

I found the solution with your help. It is:

=Max(Aggr(If(Rank(Sum({<Year = {2015}>} Sales) - Sum({<Year = {2014}>} Sales), 0, 1)<= 5, (Sum({<Year = {2015}>} Sales)-Sum({<Year = {2014}>} Sales))/Sum({<Year = {2014}>} Sales)), Dim))

Thank You.

Re: Max percent of Top 5 differences as expression

sunny_talwar — Tue, 04 Aug 2015 10:52:16 GMT

Awesome

I am glad you were able to find a solution and I was able to guide you towards finding one.

Best,

Sunny