topic date calculation from today in QlikView

date calculation from today

userid128223 — Wed, 06 Jun 2012 14:00:42 GMT

Hi I am looking for equation that will do following.

Fields:

ServicePurchaseDate

hours purchase

hours worked

if ServicePurchasedate is less then 12 months (from current selection) (or from today) then hours purchase - hours worked. if not then show 0. If hours worked acceds hours purchase then show negative number

date calculation from today

Wed, 06 Jun 2012 14:11:21 GMT

Hi,

just to be sure to well understand your question, could you please give us an example of what you're looking for?

Thanks

Giampiero

Re: date calculation from today

yvesqlik — Wed, 06 Jun 2012 14:14:53 GMT

if(year2date(ServicePurchaseDate),hours purchase-hours worked,0)

date calculation from today

userid128223 — Wed, 06 Jun 2012 14:15:20 GMT

if ServicePurchaseDate is less then 12 months from current date, then hours purchase - hours worked.

thanks

date calculation from today

swuehl — Wed, 06 Jun 2012 14:15:47 GMT

Maybe something like

=if([ServicePurchaseDate] > addmonths( today() ,-12), [hours purchases] - [hours worked],0)