topic Difference Between Two Day's in QlikView

Difference Between Two Day's

Fri, 05 Aug 2011 05:25:22 GMT

How can I find out the difference between two days?? Including the holidays.

Example:

(08/01/2011 08/05/2011) = 4 days

Difference Between Two Day's

kaushiknsolanki — Fri, 05 Aug 2011 07:10:22 GMT

Hi,

If the field contains only date then you can try this.

Date1 - Date2.

Regards,

Kaushik Solanki

Difference Between Two Day's

SunilChauhan — Fri, 05 Aug 2011 07:19:11 GMT

Date#('08/01/2011' - '08/05/2011')

forr two fields

Date#(DateField1-DateField1)

Difference Between Two Day's

Fri, 05 Aug 2011 07:43:37 GMT

Actually I want to find out the total no of days from a particular Date to Today() date. It's needed for age analysis.

Difference Between Two Day's

SunilChauhan — Fri, 05 Aug 2011 07:46:12 GMT

Date(Today())-Datefield

Difference Between Two Day's

Fri, 05 Aug 2011 07:49:48 GMT

Thank you Koushik and Sunil. Sunil I try your code but it's only show ' - '.

Actually I have a field P.date and I want to find out the difference between P.date and today(). That means whenever I run the application it's shown the difference between P.date and this particular date.

Difference Between Two Day's

kaushiknsolanki — Fri, 05 Aug 2011 07:59:32 GMT

Hi,

Try this.

Create a chart with P.Date as Dimension and expression as Today() - P.Date.

Regards,

Kaushik Solanki

Difference Between Two Day's

Fri, 05 Aug 2011 09:22:13 GMT

Thank you Koushik, it's work fine. There is any way to solve this issue on script level???

Difference Between Two Day's

kaushiknsolanki — Fri, 05 Aug 2011 09:23:54 GMT

Hi,

At script level you can try this.

Load

Today() - p.Date as Day_Difference

From xyz.

Regards,

Kaushik Solanki

Difference Between Two Day's

kaushiknsolanki — Fri, 05 Aug 2011 09:35:30 GMT

Hi,

If you got the answer can you please mark this post as answered.

Regards,

Kaushik Solanki

Difference Between Two Day's

Mon, 09 Jan 2012 02:50:19 GMT

I am trying to subtract two date's and the result was displaying on chart was '-'. The data format are YYYY-MM-DD HH:MI:SS. Please let me know what I am missing hear.

Thanks.