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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie777
Partner - Creator III
Partner - Creator III

Previous Year set

Hello,

I'd like to write a set sum expression where the chart always shows 1 year previous to the selected year.  I want to have the multi year chart so the expression below does not work 

Sum({$<[Date-Posting Date.autoCalendar.Year] = {$(=Year(Today())-1)}>}[Expenses])

where the chart will be limited to 1 year only which is previous year to the current year.  

I want to have the chart for multi year, which the current year shows the previous year YTD figure, then I can apply current year minus previous year to get the YOY difference.  

Newbie7_0-1624966301891.png

I'd greatly appreciate if someone can let me know how to write multi year previous year set expression.  

Thank you for your help.

0 Replies