previous year & current year sales

[Gayathri_Reddy5]

Hi,

I am new to Qlik sense so I need help regarding calculating Previous and Current Year sales to my report.

I have an excel data file with Order Date, Cus Name, and Sales amount.  

Do I need to add any calendar table? can anyone please help me with this?

Thanks in advance.

[anat]

create OrderYear field based on "Order Date " then use below expressions,

Current_Year

Sum({<OrderYear = {$(=Max(OrderYear))}>} Sales)

Last_Year

Sum({<OrderYear = {$(=Max(OrderYear-1))}>} Sales)