topic can any one explain this ? in QlikView

can any one explain this ?

Thu, 30 Oct 2014 10:02:43 GMT

YeartoDate(TempDate)*-1 as CurYTDFlag,

YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,

Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,

how it works pls?

Re: can any one explain this ?

alexandros17 — Thu, 30 Oct 2014 10:11:52 GMT

YeartoDate(TempDate)*-1 as CurYTDFlag,

yeartodate return true if date fall in the year of the date so if it is true (that is -1) multiply by -1 and have 1, if it is false (that is 0) you have 0

YeartoDate(TempDate,-1)*-1 as LastYTDFlag,

The same as previous but for previous year

inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,

returns true if date falls inside the year computed from Monthstart($(varMaxDate)),-1) that is the starting date of the month before the one indicated by the variable

Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,

this returns a string with the week of the date of weekstart and its year

Re: can any one explain this ?

its_anandrjs — Thu, 30 Oct 2014 10:21:52 GMT

Hi,

YeartoDate(TempDate)*-1 as CurYTDFlag,

This is calculates the values as true and false depends on the result YeartoDate returns the true and false according to the result it gives output as 1 and 0

YeartoDate(TempDate,-1)*-1 as LastYTDFlag,

This calculates the previous year values as 1 and 0

inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,

Returns true if date lies inside the year containing Monthstart($(varMaxDate)) and according to that multiples.

Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,

And this returns the Week of the weekstart(TempDate)

Regards

Anand