Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Master II
Partner - Master II

example :

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

View solution in original post

1 Reply
giakoum
Partner - Master II
Partner - Master II

example :

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