Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Calculating MTD, YTD, RTM

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

CompanyMonthYearSales
ABCJAN-201230
ABCFEB-201220
XYZJAN-201230

Regards,

Gyana

2 Replies

Re: Calculating MTD, YTD, RTM

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


talk is cheap, supply exceeds demand
omarbensalem
Esteemed Contributor

Re: Calculating MTD, YTD, RTM

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

YTD, MTD issue

Hope that helps