topic Pivot Table in QlikView

Pivot Table

upaliwije — Sun, 28 Feb 2016 02:43:30 GMT

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

Re: Pivot Table

upaliwije — Sun, 28 Feb 2016 03:40:14 GMT

Dear Experts

Can you please suggest some solution to my problem

Thanks

Re: Pivot Table

sunny_talwar — Sun, 28 Feb 2016 12:37:56 GMT

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

Re: Pivot Table

upaliwije — Mon, 29 Feb 2016 03:36:22 GMT

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

Re: Pivot Table

upaliwije — Tue, 01 Mar 2016 11:34:20 GMT

Dear Friends

Pls help me a solution