topic Re: Growth % in QlikView

Growth %

upaliwije — Tue, 28 Jan 2014 06:51:24 GMT

I am applying the following expression to calculate the growth rate as per user selection and it is working fine. But when I have negative figure of Premium for Previous period growth rate calculates wrong rate.

Eg Premium for the Current period is 100,000

Premium for the previous period is -25,000

Growth Rate given by the following expression is -500%

But the correct rate should be 500%

pls help me correct the expression to calculate correctly

(sum({$<PERIODID = {"<=$(=Max(PERIODID))"},YEAR ={$(=Max(YEAR))},QUARTER =,MONTH =,PERIOD =>}[PREMIUM])

-sum({$<PERIODID = {$(=Max(PERIODID)-12)},YEAR =,QUARTER =,MONTH =,PERIOD =>}[PREMIUM]))

/sum({$<PERIODID = {$(=Max(PERIODID)-12)},YEAR =,QUARTER =,MONTH =,PERIOD =>}[PREMIUM])*100

Re: Growth %

Gysbert_Wassenaar — Tue, 28 Jan 2014 07:03:58 GMT

You can calculate the absolute value of the growth rate by using the fabs function:

fabs( ...your_expression_here... )

Re: Growth %

upaliwije — Tue, 28 Jan 2014 07:09:05 GMT

Dear Gysbert

Where should I actually type fabs command. Kindly reproduce my expression having inserted the fabs function in the right place

Thanks

Re: Growth %

MK_QSL — Tue, 28 Jan 2014 07:15:23 GMT

Fab(

(sum({$<PERIODID = {"<=$(=Max(PERIODID))"},YEAR ={$(=Max(YEAR))},QUARTER =,MONTH =,PERIOD =>}[PREMIUM])

-sum({$<PERIODID = {$(=Max(PERIODID)-12)},YEAR =,QUARTER =,MONTH =,PERIOD =>}[PREMIUM]))

/sum({$<PERIODID = {$(=Max(PERIODID)-12)},YEAR =,QUARTER =,MONTH =,PERIOD =>}[PREMIUM])*100)

Re: Growth %

upaliwije — Tue, 28 Jan 2014 08:13:49 GMT

It is working

Thanks a lot