topic Calculating weekly growth in QlikView

Calculating weekly growth

Wed, 09 Jan 2013 06:39:15 GMT

Hi Guys,

I want to calculate weekly growth in a table. I have also attached a file which tells how my table should look like. I want to know that which expression should i use so that even if change the sorting of data week coloumn, then also the growth should be correct for that corresponding data week. In simple words, my growth should be irrespective of the sorting of data week.

Re: Calculating weekly growth

Wed, 09 Jan 2013 08:27:49 GMT

I think you should use the Chart Inter Record Functions, like the Above() function to refer to other rows in the chart table. For example, the following expression: Sum(Sales) - Above(Sum(Sales))

Re: Calculating weekly growth

Wed, 09 Jan 2013 08:35:37 GMT

Thanks juan for the reply. I tried the same thing but then if i change the sorting of the column data week, then the growth will also change. I want an expression which should be irrespective of the sort order of data week.

Re: Calculating weekly growth

Wed, 09 Jan 2013 09:13:03 GMT

Hi ,

Why don't you calculate the growth in the backend , then sorting the column data week or any other column wont affect the growth calculation

Re: Calculating weekly growth

Wed, 09 Jan 2013 09:25:31 GMT

sum(([Net Amount]))-Above(sum([Net Amount]))

this expression is works

Re: Calculating weekly growth

Wed, 09 Jan 2013 10:19:38 GMT

Hi,

PFA.

Regards,

Kabilan K.