Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

mario-sarkis
Contributor II

Time


Dear aLL

i Have to variable

vYearstart=num(Daystart(YearStart(Date(max(PeriodDate)))))

vMaxDate=Max({1<Year=$::Year,Month=$::Month,Quarter=$::Quarter,MonthName=$::MonthName,Day=$:Smiley Very Happyay>} PeriodDate)

i am Seeing the YTD profit using

PeriodDate={">=$(vYearStart) <=$(vMaxDate)"}

I need to Seen the same Period of Time as per last year

help please,

2 Replies
MVP & Luminary
MVP & Luminary

Re: Time

Maybe like this: PeriodDate={">=$(=addyears($(vYearStart),-1))<=$(=addyears($(vMaxDate),-1))"}

If not, please post a qvw document that demonstrates the problem.


talk is cheap, supply exceeds demand

Re: Time

You can try with Addmonths() also

PeriodDate={">=$(=Addmonths($(vYearStart),-12)) <=$(=Addmonths($(vMaxDate),-12))"}


Community Browser