Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
karthikoffi27se
Creator III
Creator III

Renewal Rate

Hi All,

I have a requirement to calculate renewal rate for the year 2016, 2017 and 2018. 

Can you please help me to achieve this.

Many Thanks

5 Replies
shiveshsingh
Master
Master

What is the formula to calculate the Renewal rate?

karthikoffi27se
Creator III
Creator III
Author

The formula for that is say for example in 2016 there are 100 policies and 2018 there are 150 policies out of 150 policies I got 70 as renewal and 80 as New policies, so the renewal rate is 70/100 = 70%. 

Hope this helps.

MohammedMustaq
Partner
Partner

 

Hi,

Hope this solve!


=Sum({<PolicyType={"Renewal"},Year={"$(vMaxYear)"}>}Policies)
/
Sum({<PolicyType={"New"},Year={"<$(vMaxYear)"}>}Policies)

 

OR

 

=Sum({<PolicyType={'Renewal'},Year={"$(vMaxYear)"}>}Policies)
/
Sum({<PolicyType={'New','Renewal'},Year={"<$(vMaxYear)"}>}Policies)

 

vMaxYear=Max(Year)

 Thanks

Mustaq

shiveshsingh
Master
Master

How are you defining the new and existing policy? is there a flag?

Can you share some sample data to work upon?

haribabugv
Creator
Creator

Hello Karthik

May be you can check this file for the calculations.

You can also do by using peek function in the script.

Renewal.JPG