Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I was trying to understand YearToDate function in QlikSense Help and i am unable to understand the following:
How can this be true for a script reload date of 18/11/2011 ?
Here ('2010-11-18', -1) would offset to date '2009-11-18' right? And '2009-11-18' does not fall in the range of '2011/01/01 to 2011/11/18' which YearToDate function is calculating.
Please let me know if I am missing any logic here or Qlik help needs an update here.
The offset is applied to the last reload date. So in the example the -1 offset moves 2011-11-18 to 2010-11-18 and then tests if 2010-11-18 is in 2010.
Hence, TRUE is returned for yeartodate( '2010-11-18', -1).
The offset is applied to the last reload date. So in the example the -1 offset moves 2011-11-18 to 2010-11-18 and then tests if 2010-11-18 is in 2010.
Hence, TRUE is returned for yeartodate( '2010-11-18', -1).
Thanks ManuelLindekeit.
I was thinking the offset is applied on the expression date. Thanks for the clarification.