topic Comparative annual in QlikView

Comparative annual

analunasaucedo — Mon, 01 Aug 2011 10:40:25 GMT

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 — Mon, 01 Aug 2011 10:41:57 GMT

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 — Mon, 01 Aug 2011 11:08:33 GMT

Thank you very much.