YeartoDate

[Anonymous]

Hi ,

Please explain yeartoDate() .In which circumstances it is used widely

Thanks

[its_anandrjs]

Hi,

From QV Help

YearToDate(date [ , yearoffset [ , firstmonth [ , todaydate] ] ])

Returns true if a date falls within the year to date, else false. If none of the optional parameters are used, the year to date means any date within one calender year from January 1 up to and including the date of the last script execution.

Examples:

Assume last reload time = 1999-11-18

yeartodate( '1998-11-18') returns false

yeartodate( '1999-02-01') returns true

yeartodate( '1999-11-18') returns true

yeartodate( '1999-11-19') returns false

yeartodate( '1998-11-18', -1) returns true

yeartodate( '1999-11-18', -1) returns false

yeartodate( '1999-04-30', 0, 5) returns false

yeartodate( '1999-05-01', 0, 5) returns true

Regards

Anand

[Anonymous]

YTD differs from company to company, like:

• Its Starting Year(YearStart) to Current selected date

• financial Year to current selection date

You can use set analysis to achieve YTD

Check below links :

http://community.qlik.com/docs/DOC-1319

http://community.qlik.com/message/198370#198370

Regards

Neetha