topic Re: Growth in QlikView

Growth

upaliwije — Wed, 27 May 2015 15:52:04 GMT

Hi Friends

I attach h/w my QV document where my formula for growth calculation does not work. pls look into this and correct me.

Re: Growth

sunny_talwar — Wed, 27 May 2015 15:55:25 GMT

Use this expression:

=Sum(Premium)/Before(Sum(Premium)) - 1

Output:

Re: Growth

buzzy996 — Wed, 27 May 2015 16:03:38 GMT

problem with ur previous year expression calculation,try to modify tht part ..and see?

Re: Growth

Qrishna — Wed, 27 May 2015 16:06:47 GMT

try this. it works:

=(sum( {<YEAR={$(=max(Year))}>} [Premium] ) - sum( {<Year={$(=max(Year)-1)}>} [Premium] ))

/Fabs(sum( {<Year={$(=max(Year)-1)}>} [Premium] ))*100

Thanks

Re: Growth

upaliwije — Wed, 27 May 2015 16:17:42 GMT

Thanks sunindia

Your expression is working. But in my actual data table there is another filed and if I apply your formula it does not work. Kindly have a look at my QV document attached now !

Re: Growth

upaliwije — Wed, 27 May 2015 16:18:28 GMT

Your expression does not work

Re: Growth

sunny_talwar — Wed, 27 May 2015 16:19:56 GMT

Update: Reattaching the file as I think I attached the earlier one without saving

For me it seems to be working:

=Sum({<DESC={'GP'}>}AMOUNT)/Before(Sum({<DESC={'GP'}>}AMOUNT))-1

Re: Growth

upaliwije — Wed, 27 May 2015 16:30:33 GMT

Thanks a lot it is working

Re: Growth

sunny_talwar — Wed, 27 May 2015 16:31:18 GMT

No Problem