Expression

upaliwije — Wed, 07 Oct 2015 07:06:07 GMT

I have following expression in my QV document which calculate growth rate over the last year premium. I want to show only the growth rate which is less than 0 value. Pls help me to modify the following expression to suit my requirement.

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

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

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

Re: Expression

gautik92 — Wed, 07 Oct 2015 07:12:09 GMT

if(

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

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

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

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

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

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

)

topic Expression in QlikView

Expression

Re: Expression