topic Re: how interval match with dates? in QlikView

how interval match with dates?

pratap6699 — Thu, 23 Apr 2015 11:46:27 GMT

iam using with numerics its work fine but dates wise iam not get correct result,please explain

Re: how interval match with dates?

Thu, 23 Apr 2015 11:52:05 GMT

hi,

use interval match with date format or numeric format of date because it compares the date then give result.

may be you date in string format show that interval match not working.

i will suggest you use interval match with numeric date or date like num(DATE) (it will run fast).

Regards

Vimlesh

Re: how interval match with dates?

Thu, 23 Apr 2015 11:54:04 GMT

May be your date field’s not proper format. First you can convert all field in one format then you can try.

Re: how interval match with dates?

pratap6699 — Thu, 23 Apr 2015 12:15:22 GMT

ya thanks for quick reply my dear friend...i know how to use of interval match between numerics but without converting the num format of dates is it possible...like ABC table is there which contains

ABC:

load mindate,maxdate,ename

01/05/15,20/05/15,srinu

01/04/2014,20/04/2014,pratap

02/03/2013,10/03/2013,venkat

XYZ:

load date,dept

15/05/15,sales

21/04/2014,production

02/03/2013,clerk

bridge:

interval match(date)

load mindate,maxdate resident ABC;

without converting dates into num is it possible?

Re: how interval match with dates?

anbu1984 — Thu, 23 Apr 2015 12:55:45 GMT

No it is not possible

ABC:
load Date#(mindate,'DD/MM/YYYY') As mindate,Date#(maxdate,'DD/MM/YYYY') As maxdate,ename Inline [
mindate,maxdate,ename
01/05/15,20/05/15,srinu
01/04/2014,20/04/2014,pratap
02/03/2013,10/03/2013,venkat ];
XYZ:
load Date#(date,'DD/MM/YYYY') As date,dept Inline [
date,dept
15/05/15,sales
21/04/2014,production
02/03/2013,clerk];

bridge:
IntervalMatch(date)
load mindate,maxdate resident ABC;