Comparative annual

[analunasaucedo]

Hello,

I am working with Qlikview desktop version 10.0.

I need to make an annual comparative as shown in the picture.

I need the expression to calculate selected data for the year compared to last year's data.

Can yoy help me?.

Thanks.

[lironbaram]

you can use the time chart wizard

its in the toolbars ->tools-> time chart wizard

its an easy tool to create such graph

you can also use this two expressions:

current year : sum({<YEAR={$(=max(YEAR))}>} Sales)

Previous year : sum({<YEAR={$(=max(YEAR)-1)}>} Sales)

[analunasaucedo]

Thank you very much.