topic Re: MONTH DIFFERENCE in QlikView

MONTH DIFFERENCE

Fri, 21 Apr 2017 02:31:55 GMT

Start Date End Date Desired Column Values(how to accomplish this difference on no of months between 2 Dates)

3/01/2014 6/01/2014 3

3/01/2014 7/01/2014 4

3/01/2014 8/01/2014 5

3/01/2014 9/01/2014 6

3/01/2014 10/01/2014 7

qlikview979 — Fri, 21 Apr 2017 05:08:55 GMT

Try like this

LOAD Startdate,

Enddate,

Round(num(Interval(Enddate-Startdate))/30) as check

FROM

(ooxml, embedded labels, table is Sheet1);

prma7799 — Fri, 21 Apr 2017 05:12:12 GMT

Please try this

Test:

LOAD * Inline

[

StartDate, EndDate

'3/01/2014' ,'6/01/2014'

'3/01/2014' ,'7/01/2014'

'3/01/2014' ,'8/01/2014'

'3/01/2014' ,'9/01/2014'

'3/01/2014' ,'10/01/2014'

];

NewTest:

LOAD * , (date(date#(EndDate,'DD/MM/YYYY'),'DD/MM/YYYY')) - (date(date#(StartDate,'DD/MM/YYYY'),'DD/MM/YYYY')) as Diff

Resident Test;

DROP Table Test;

PFA another Solution

Aurelien_Martinez — Fri, 21 Apr 2017 09:17:00 GMT

Hi,

You can find the solution in this doc

Anonymous — Fri, 21 Apr 2017 09:53:09 GMT

write this expression:

=Day(Interval(Date#(EndDate,'DD/MM/YYYY')-Date#(StartDate,'DD/MM/YYYY')))+1