topic Re: calculate days between two dates in QlikView

calculate days between two dates

QSense — Wed, 21 Nov 2012 08:04:05 GMT

Hello ,

I have a dimension called weekstart as you see below in list

I want to calculate how many days there are between the first dayof weekstart and creation date

I just wrote the expression min(date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY'))-date(ISTEK_ACISTARIHI2,'DD.MM.YYYY') ti

Creation date =ISTEK_ACISTARIHI2

Actually I want to calculate whether gap between the first dayof weekstart and creation date is more than 30 days or much

It means weekstart-creation date >=30

ID	Creation Date	weekstart
1	07.10.2011 11:43.44	05.11.2012
2	01.10.2012 15:53.55	12.11.2012
3	08.11.2012 15:55.52	19.11.2012

Re: calculate days between two dates

Anonymous — Wed, 21 Nov 2012 08:15:41 GMT

Does if(weekstart-[Creation Date]>=30,.....) not work for you ?

You may need to wrap each date up in a Num() function.

Jonathan

Re: calculate days between two dates

Wed, 21 Nov 2012 08:20:41 GMT

Hi,

You can try something like this:

=Interval(date(Weekstart)-date(Creation Date),'DD')

Hope that helps.

Regards,

-Khaled.

Re: calculate days between two dates

QSense — Wed, 21 Nov 2012 08:32:35 GMT

It does not work

Re: calculate days between two dates

QSense — Wed, 21 Nov 2012 08:32:49 GMT

It didnt work

Re: calculate days between two dates

QSense — Wed, 21 Nov 2012 08:42:28 GMT

What I want to do is that as you see below a field Açılış Tarihi=ISTEK_ACISTARIHI2

and durum= ISTEK_DURUM

I have created dimension calculates weekstart =date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')

and created two expression one of them is count of ISTEK_DURUM='Açık' other expression calculates

gap between weekstart and ISTEK_ACISTARIHI2 more than 30 days and ISTEK_DURUM='Açık'

What I want to do in expression 2 is how many days passed away from each weekstart

Re: calculate days between two dates

Anonymous — Wed, 21 Nov 2012 08:52:43 GMT

PFA

Re: calculate days between two dates

QSense — Wed, 21 Nov 2012 09:12:47 GMT

thank you for reply

Re: calculate days between two dates

Anonymous — Wed, 21 Nov 2012 09:27:19 GMT

plz close d discussion if ur problem is solved by checking answered

Re: calculate days between two dates

Thu, 22 Nov 2012 06:57:45 GMT

Hi,

Have you tried using:

=if(Interval(date(Weekstart)-date(Creation Date),'DD')>30,'WeekStart More Than 30 Days','Less Than 30 Days')

Hope that helps.

- Khaled.