topic Current year versus last year in QlikView

Current year versus last year

eaglemite35 — Fri, 17 Dec 2021 07:57:09 GMT

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?

Re: Current year versus last year

m_woolf — Fri, 17 Dec 2021 19:14:34 GMT

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)