topic Datediff in Qlikview in QlikView

Datediff in Qlikview

Tue, 20 Jul 2010 07:41:15 GMT

Hi,

Is there any way to find the datediff in QlikView or any relevant functions in Qlikview?????.

Regards,

XXX

Datediff in Qlikview

suniljain — Tue, 20 Jul 2010 08:05:45 GMT

Dear

Date(Date1)-Date(Date2) as Date_Diff

You can use this logic at script level as well as in sheet object.

Regards

Sunil

Datediff in Qlikview

Tue, 20 Jul 2010 08:58:31 GMT

Thanks Sunil.

Let me check and update on how it works.................

Datediff in Qlikview

Tue, 20 Jul 2010 11:13:54 GMT

write this micro in macro editor

function datediff3(d1,d2)
datediff3=datediff("D",Date1,Date2)
end function

then call this macro in script

As datediff2(Date1,Date2)

Regards

Ashish Srivastava

Datediff in Qlikview

Tue, 20 Jul 2010 14:30:07 GMT

Thanks Ashish ..

My requirement is to find the age (Currentdate- Datefeild) at the Object level and count of that specific Age.

I am using the now () fucntion currently. Is there any other function to get the System current date

Regards,

XXX

Datediff in Qlikview

Wed, 21 Jul 2010 06:07:14 GMT

Age() function is there in qlikview please use this finding the age.

Regards

Ashish Srivastava

Datediff in Qlikview

Wed, 21 Jul 2010 06:20:31 GMT

Thanks Ashish,

Age will give you the result in terms of years . I am looking in terms of Days. is there any other option for the same?

Regards,

XXX

Datediff in Qlikview

Wed, 21 Jul 2010 07:23:39 GMT

Use this macro

function datediff3(d1,d2)
datediff3=datediff("D",Date1,Date2)
end function

then call this macro in script

datediff3(today(),[persion birth date])

this way you find the number of day.

Regards

Ashish

AW:Re: Datediff in Qlikview

brenner_martina — Wed, 21 Jul 2010 08:19:49 GMT

Hi,

there a lot of datefunctions, for a difference you can use the following

Num(Year(Date1)) - Num(Year(Date2)) --> gives the yeardiff
Num(Month(Date1)) - Num(Month(Date2)) --> gives the wonthdiff
Num(Week(Date1)) - Num(Week(Date2)) --> gives the weekdiff
Num(Date1) - Num(Date2)) --> gives the daydiff

and so on!

AW:Re: Datediff in Qlikview

Wed, 21 Jul 2010 09:01:31 GMT

ya i know but the help of datediff you get integer value.

Regards

Ashish Srivastava