Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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?

Labels (1)
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])