topic Re: YearToDate() in QlikView

YearToDate()

tripatirao — Fri, 25 Sep 2015 06:51:07 GMT

Hi all

Can any one explain about YearToDate()...?

Thanks

Re: YearToDate()

gautik92 — Fri, 25 Sep 2015 06:52:19 GMT

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.

Re: YearToDate()

tripatirao — Fri, 25 Sep 2015 07:28:19 GMT

Hi avinash

Can you tell me how this expression works.

I am trying to find YeartoDate Dynamically

-Sum(Sales * YearToDate(Date, 0, 4, vYEDate))

the value of vYEDate=41364(31st march 2013)

Re: YearToDate()

jonathandienst — Fri, 25 Sep 2015 07:32:21 GMT

I have never used it like this, but that should work - it will give all sales in FY 2012/3. Is that what you want? What are you getting?

Re: YearToDate()

stephenedberkg — Fri, 25 Sep 2015 10:05:47 GMT

i hope this attachment is more useful for you

Re: YearToDate()

jrdunson — Fri, 25 Sep 2015 12:00:50 GMT

Tripati

Could you use a flag field in the load script?... something like:

Load

SaleDate,

SaleAmt,

if( DayNumberOfYear(SaleDate) < DayNumberOfYear(date(now())), 1, 0) as as [SalesYTD]

Then in in your expression

Sum({$<[SalesYTD]={1}>} SaleAmt)

This would be 'dynamic' - per each reload...

Just two cents

Jarrell