How to do a Period over Period Analysis in Qlik Sense

[#1]

I have a Sales Database. One of the Measure is SalesAmount. I have created some master items like drop-down hierarchy dimension called date (Year>Quarter>Month). I want to do YTD, MTD, QTD & also YTY, QTQ , MTM analysis. Please give me some guidelines as to implement Period over Period Analysis. If possible can you give me the expression used for YTD, MTD, QTD & also YTY, QTQ , MTM.

Thank you.

Regards,

Leroy

[#2]

Hi Leroy,

I responded to your other post (How to find the average of sales by Year, Quarter, Month excluding the Years/Quarters/Month that hav...) and that answer may assist with this question.

Hope this helps.

Rod

[jagan]

Hi,

Check this

For YTD

=Sum({<Year=, Month=, Quarter=, DateFieldName={'>=$(=YearStart(Today()))<=$(=Today())'}>} Sales)

MTD

=Sum({<Year=, Month=, Quarter=, DateFieldName={'>=$(=MonthStart(Today()))<=$(=Today())'}>} Sales)

QTD

=Sum({<Year=, Month=, Quarter=, DateFieldName={'>=$(=QuarterStart(Today()))<=$(=Today())'}>} Sales)

Hope this helps you.

Regards,

Jagan.