topic Dates comparison in QlikView

Dates comparison

Thu, 26 Sep 2013 13:33:02 GMT

Hi ,

I am new to Qlikview..

I Have one requirement like " Calls / complaints that take maximum resolution time "

In Excel Sheet there are two date columns like

Date 1 Date 2

---------------- ---------------------

08/09/2013 10/09/2013

So i Wanna display maximum resolution time like

I am excepting the following Result .Please let me know me how to calculate difference b/w two date values.

Date 1 Date 2 Max days

---------------- ----------------- ----------------

08/09/2013 10/09/2013 3

Please Give me any suggestions.

Regards,

Vinod

Re: Dates comparison

srchilukoori — Thu, 26 Sep 2013 14:21:03 GMT

Dates are stored as dual values. You can subtract Date2 from Date 1 directly and obtain the result.

e.g.:

Max Days = <Date 2> - <Date 1>

Additionally, you can use some formatting if needed

Max Days = Num(Date#(<Date 2>, 'MM/DD/YYYY') - Date#(<Date 1>, 'MM/DD/YYYY'))

Re: Dates comparison

MayilVahanan — Thu, 26 Sep 2013 14:27:13 GMT

Create a field from script itself, by subtracting two fields. And use tat. Hope that helps

Re: Dates comparison

ngulliver — Thu, 26 Sep 2013 14:58:42 GMT

HI, Vinod.

I have had to do something very similar and have used the 'floor' function in the calculation to round downwards to the next full amount (see QlikView help for 'floor' usage). This is particularly useful if you are dealing with hours in the day too.

floor(([Date1] - [Date2])) as [Days To Resolve],

Regards,

Neil

Re: Dates comparison

CELAMBARASAN — Thu, 26 Sep 2013 15:12:46 GMT

Use Interval(Date2-Date1, 'd')

It gives you the number of days between the date.

Re: Dates comparison

Mon, 30 Sep 2013 10:23:54 GMT

Thanks

Re: Dates comparison

Mon, 30 Sep 2013 10:24:02 GMT

Thanks

Re: Dates comparison

Mon, 30 Sep 2013 10:24:09 GMT

Thanks