How to plot this table

[#1]

Hi,

      I have this unique requirement where I display the year in row and column and the policy count within the cells with certain logic. I have attached the sample data and the logic to calculate it along with the qlikview document, I want to achieve the same result through qlikview. I tried with before, after, first etc but didn't get the desired results.

Basically the data represents count of policy that were issued in the respective year and how many of them remained active in the subsequent years.

For eg. row 1 shows 21 policies issued in 2001 out of which 19 remained active in 2002 etc.

Thanks in advance,

Lax

[#2]

Hi, Is it possible through qlikview with the given data model. Can the experts check it out ?

Thanks,

Lax