How to plot this table

Wed, 23 May 2012 13:11:37 GMT

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

pivot with same dimension on x & y or row and column

Fri, 25 May 2012 10:14:08 GMT

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

Thanks,

Lax

topic How to plot this table in QlikView

How to plot this table

pivot with same dimension on x & y or row and column