topic Re: Calculate Days in QlikView

Calculate Days

Fri, 08 Aug 2014 07:39:50 GMT

Hi,

I have two calendar objects for start date and end date.

When i select dates in these objects, i want to calculate how many days and place it in a textbox.

How can I achieve this??

For ex :

Start
Date

End Date

01-Jul-14

06-Jul-14

Duration

Regards,

Shruthi

VishalWaghole — Fri, 08 Aug 2014 07:56:59 GMT

Hi Shruthi,

Try this

=GetFieldSelections(End Date)-GetFieldSelections(Start Date)

Hope it work for you.

-- Regards,

Vishal Waghole

Fri, 08 Aug 2014 08:02:51 GMT

datee:

load * inline

[startdate, enddate

23-MAY-2014,28-MAY-2014

];

load date#(enddate,'D-MMM-YYYY' ) - date#(startdate,'D-MMM-YYYY') as ed Resident datee;

set

"=ed"

in Text object >properties > general tab > text

MK_QSL — Fri, 08 Aug 2014 08:24:55 GMT

Try

=Interval(Date(Date#([End Date],'DD-MMM-YYYY')) - Date(Date#([Start Date],'DD-MMM-YYYY')),'dd')

=Interval(Date(Date#(Max([End Date]),'DD-MMM-YYYY')) - Date(Date#(Max([Start Date]),'DD-MMM-YYYY')),'dd')

DavidFoster1 — Fri, 08 Aug 2014 10:03:38 GMT

I think some detail got lost in translation there.

Could you provide some sample data (at least 2 rows) and the desired result?

Fri, 08 Aug 2014 10:12:26 GMT

Try the interval key function to get those values inbetween the two dates