topic Current Year as Set Analysis in QlikView

Current Year as Set Analysis

lucarizziero — Tue, 05 Jan 2010 21:21:57 GMT

Hi all,

I'd like to use a set analysis instruction in order to select current year data.

Something like

sum ( {$<year={2009}>} sales)

instead of

sum(if(year=2009,sales))

but varying the year 2009 to the current year.

Thanks to all.

Current Year as Set Analysis

Tue, 05 Jan 2010 21:26:15 GMT

Sum({$<Year={$(=Year(Today()))}>} Sales)

Some people instead base it on their data:

Sum({$<Year={$(=Max(Year))}>} Sales)

That would pull for the highest year in your data set. For example if you hadn't loaded any new 2010 data yet and wanted to consider 2009 the current year. Sometimes basing it on your data is preferrable to the system date, which is what the first one would get you.

Current Year as Set Analysis

lucarizziero — Tue, 05 Jan 2010 21:37:50 GMT

That's perfect: thanks for your courtesy.

Luca