Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Expression

Hi

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

1 Solution

Accepted Solutions
gautik92
Specialist III
Specialist III

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

)

View solution in original post

1 Reply
gautik92
Specialist III
Specialist III

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

)