topic Re: Can someone help me With this: in QlikView

Can someone help me With this:

Tue, 05 Apr 2016 11:04:46 GMT

I need a formula for a growth rate by year in a combo Chart:

Dimension (years 2011-2016);
First measure - sum(sales)
Second measure - i need a growth rate comparing the previous year. Example 2012 grew 10% from 2011, 2013 grew 5% from 2012...

Re: Can someone help me With this:

Gysbert_Wassenaar — Tue, 05 Apr 2016 16:08:53 GMT

Try sum(sales)/above(sum(sales))-1

Re: Can someone help me With this:

sunny_talwar — Tue, 05 Apr 2016 16:09:22 GMT

May be this:

Sum(Sales)/Above(Sum(Sales)) - 1

Re: Can someone help me With this:

Wed, 06 Apr 2016 08:17:06 GMT

Thanks,

But The formula don´t work and returns "error in expression".

Re: Can someone help me With this:

sunny_talwar — Wed, 06 Apr 2016 10:14:33 GMT

Do you have a sample you can share?

Re: Can someone help me With this:

Wed, 06 Apr 2016 10:33:42 GMT

Sorry, i´m new here. What kind of sample you want?

Re: Can someone help me With this:

Wed, 06 Apr 2016 10:50:23 GMT

if(year=2011),sum(sales),if(sum(sales)>above(sum(sales))),((sum(sales)-above(sum(sales)))/above(sum(sales)))*100,((above(sum(sales)-sum(sales)))/above(sum(sales)))*100

if(sum(sales)>above(sum(sales)),((sum(sales)-above(sum(sales)))/above(sum(sales)))*100,(above(sum(sales))-sum(sales))/above(sum(sales)))*100)