Yearly Value by Historic Years Automatically

Tue, 18 Sep 2012 10:02:43 GMT

Hi Guys,

I calculate a value for spend by customers and compare against historic figures.

I have a set expression for each year at the moment

sum({<Year={'2012'}>}[Invoice Value])

sum({<Year={'2011'}>}[Invoice Value])

sum({<Year={'2010'}>}[Invoice Value])

etc

i would like to fix this in permanently rather than adding one each year going forward, for example using Year=(vToday)-1 , -2, -3, -4 etc for the past 5 years for example.

Any ideas how to achieve this?

Re: Yearly Value by Historic Years Automatically

Anonymous — Tue, 18 Sep 2012 10:05:44 GMT

Sure, you can use:

sum({$<Year={$(=Year(Today())-X)}>} [Invoice Value])

Where X represents how many years you want to subtract from today.

topic Re: Yearly Value by Historic Years Automatically in QlikView

Yearly Value by Historic Years Automatically

Re: Yearly Value by Historic Years Automatically