Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Different year in one chart

Hi,

in my table I have invoice data of different years. In one chart I want to show the ammount per month (from a selected year) and the ammount per month (from the selected year minus 1). How could I do this?

1 Solution

Accepted Solutions
giakoum
Honored Contributor II

Re: Different year in one chart

example :

sum({$<Year={"$(=only(year-1))"}>} [value])

1 Reply
giakoum
Honored Contributor II

Re: Different year in one chart

example :

sum({$<Year={"$(=only(year-1))"}>} [value])

Community Browser