Current year versus last year

[eaglemite35]

Hi there,

I am mainly a Tableau guy, but I have an issue with Qlikview where I have to offset the current year versus last year. I'm sure it's an easy thing, but I can't find out what the solution might be. Can anyone help?

[m_woolf · Accepted solution]

You can use set analysis for this.

If you are trying to sum a field:

Current year is : =Sum({$<Year={$(=max(Year))} Fieldname)

Previous year is: =Sum({$<Year={$(=max(Year)-1)} Fieldname)