Calculating MTD, YTD, RTM

[#1]

Hi ,

One of my requirement is to calculate MTD,YTD and RTM.Please help me how to do this calculation in Qlik Sense.

Below is my sample data

Company	MonthYear	Sales
ABC	JAN-2012	30
ABC	FEB-2012	20
XYZ	JAN-2012	30

Regards,

Gyana

[Gysbert_Wassenaar]

See The As-Of Table‌. It allows you to calculate these things.

[OmarBenSalem]

Please refer to this thread; I tried to explain it step by step:

YTD, MTD issue

Hope that helps