How to use previous Year and Current year Premiums as two different expression in Chart

[#1]

hello
we calculate the increase in premiums over several years (2010,2009,2008 ,...). How can I do this comparison are viewing the results for all selected years together?

premiums year increase

300 2010 (300/200)-1

200 2009 (200/100)-1

100 2008 ....

etc

as I can see the result of the increase for all selected years together?

[#2]

Hi,

Find the attachment.For any clarification let me know the same.

Thanks & Regards

Jai

[#3]

I can not read the attached file because I have a trial version of QlikView .. you can try to explain what you did?

[#4]

Hi,

I have taken the difrrence of the premiums for respective year,

(((

Sum(if(year(addmonths(Today(),-24))=Year,premiums)))/Sum(if(year(addmonths(Today(),-36))=Year,premiums)))-1)*(-1) -

It will give you the premium valuesdifrrence between the year of 2007-2008

(((

Sum(if(year(addmonths(Today(),-12))=Year,premiums))) /Sum(if(year(addmonths(Today(),-24))=Year,premiums)))-1)*(-1)

It will give you the premium valuesdifrrence between the year of 2008-2009

(

Sum(if(year(addmonths(Today(),-12))=Year,premiums))/(Sum(if(Year(Today())=Year,premiums)))-1)*(-1)

It will give you the premium valuesdifrrence between the year of 2009-2010.

Try to put in Pivot table.For any issues let me know.

Thanks & Regards

Jai

[#5]

the problem is that we are working with pivot tables, and our year is a variable size (expressed as the number 2008-2009-2010).
We would like if we select 2008 and 2009 in the pivot table a comparison is made between 2009 and 2008 and between 2008 and 2007. We have applied this Set Analysis, but we can not simultaneously have two comparisons

(sum({$ <anno_di_chiusura={$(ANNO)},bilancino_sintetico={'B1 premi prodotti'}>}importo)