Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Pivot Table

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

4 Replies
upaliwije
Creator II
Creator II
Author

Dear Experts

Can you please suggest some solution to my problem

Thanks

sunny_talwar

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)?

upaliwije
Creator II
Creator II
Author

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

Class2012201320142015
0011
(1C000070)(1C000040)

Your early attention is much appreciated

upaliwije
Creator II
Creator II
Author

Dear Friends

Pls help me a solution