Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mario-sarkis
Creator II
Creator 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=$::Day>} 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
Gysbert_Wassenaar

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
its_anandrjs

You can try with Addmonths() also

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