Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

YTD,QTD,MTD,WTD IN Qlik Sense

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

 

1 Reply
Sameer9585
Contributor II

Re: YTD,QTD,MTD,WTD IN Qlik Sense

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)