Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have developed a QV document with details of Insurance Policies where I have crated a Table (table 2) with policies renewed for continues policy periods . Now I want to create a similar table which should show no of policies done during a particular year(new+renewal) which were not not renewed in subsequent years. Can you help me to create this table please. I have attached my QV document with sample data.
Kindly help me find a solution
Dear Experts
Can you please suggest some solution to my problem
Thanks
When you say subsequent years? Are we talking about years ahead and how many years ahead are we talking about? 2,3,4,5? or did you mean subsequent year (just 1 year)?
Hi sunny
I mean If a policy is not renewed in a year that is what I want to count.
Eg Policy No NI00121C000070 is not renewed in 2014
Policy No NI00111C000040 is not renewed in 2015
Such data should be shown in table like given below
Class | 2012 | 2013 | 2014 | 2015 |
0 | 0 | 1 | 1 | |
(1C000070) | (1C000040) |
Your early attention is much appreciated
Dear Friends
Pls help me a solution