topic Re: YeartoDate in QlikView

YeartoDate

Anonymous — Sat, 17 Jan 2015 10:18:15 GMT

Hi ,

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

Thanks

Re: YeartoDate

its_anandrjs — Sat, 17 Jan 2015 12:49:03 GMT

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

Re: YeartoDate

Anonymous — Sat, 17 Jan 2015 13:41:55 GMT

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