Displaying Last Year as a column in a table.

[ProfPhidd]

I want to show my Buyers(sales people) as rows and then show Sales.lastYear as columns.

Here is my expression but its not returning Last Year's Sales.  Is there a CurrentYr(), PreviousYr() or other Relative Date function in Qlik Sense like we have in IBM Cognos?

=sum({$<PriorYr={$(Year(TRANSACTION_DATE),-1)}>} SALES)

[Or]

A set analysis expression should be phrased as SomeField = {SomeValue}, so you would be looking at something like

=Sum({<TRANSACTION_DATE= {"=Year(Today())-1"} >} SALES)

I'm not aware of a current year or previous year direction functions, but they seem rather unnecessary considering Year(Today()) is available. If you're so inclined, you can set up a variable or field in your app using Year(Today()) and reference that field or variable.