YTD,QTD,MTD,WTD IN Qlik Sense

[iswarya]

Show the price of the item along with the needed metrics and dimensions in MTD,YTD,QTD.

[Sameer9585]

QTD--Sum({<Date = {"$(='>=' & Date(QuarterStart(Max(Date)), 'MM/DD/YYYY')
& '<=' & Date(Max(Date), 'MM/DD/YYYY'))"}>} Price)


MTD -- Sum({<Date = {"$(='>=' & Date(MonthStart(Max(Date)), 'MM/DD/YYYY')
& '<=' & Date(Max(Date), 'MM/DD/YYYY'))"}>} Price)


YTD -- Sum({<Date = {"$(='>=' & Date(YearStart(Max(Date)), 'MM/DD/YYYY')
& '<=' & Date(Max(Date), 'MM/DD/YYYY'))"}>} Price)


WTD -- Sum({<Date = {"$(='>=' & Date(WeekStart(Max(Date)), 'MM/DD/YYYY')
& '<=' & Date(Max(Date), 'MM/DD/YYYY'))"}>} Price)