topic Re: Growth Rate in QlikView

Growth Rate

tracycrown — Wed, 21 Oct 2015 23:41:16 GMT

Dear all

Can someone help to explain why following script does not work in expression ?

Type	2012	2013	2014	2015
Sales	1000	1500	1200	2200
		50%	-20%	83%
(sum(if(Type='Sales',Data))-Before(sum(if(Type='Sales',Data))))/Before(sum(if(Type='Sales',Data)))

Thank you

Tracy

sinanozdemir — Thu, 22 Oct 2015 02:12:31 GMT

Hi Tracy,

I tried to mimic your data-set, the if statement works for me. Maybe you have extra space in the type field so try trim() function.

Sum(If(Trim(Type) = 'Sales', Data)) and here is my expression:

If that doesn't work, try set analysis with Sum({<Type={'Sales'}>} Data).

Hope this helps.

tracycrown — Thu, 22 Oct 2015 03:40:44 GMT

Dear Sinan Ozdemir

I can compute the % but nothing shown on the chart, please advise.

Thank you

Tracy

krishna20 — Thu, 22 Oct 2015 05:13:39 GMT

Hi,

Here is your output. Pls find the attached doc.

Edited by : Krishna

bimala0507 — Thu, 22 Oct 2015 07:20:44 GMT

Hi:

Before function works only in Pivot table not any other chart. To see the value replace before with above.

Kind Regards,

Bimala