topic Interval match issue in QlikView

Interval match issue

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have used the interval match to pull [# Sales Closed] information for start and closure date.

But I'm not able to get the map the information.

Table1:

load

date(Calendar_Date,'DD-MMM-YYYY') as [Calendar Date]

,Closed as [SC# SALES Closed]

FROM

[..\5_QVD\F_CAP_Sales_Handling.qvd]

(qvd);

Table2:

load

date(Floor(Start_Date),'DD-MMM-YYYY') as [Start Date]

,date(Floor(Closure_Date),'DD-MMM-YYYY') as [Closure Date]

FROM

[..\5_QVD\D_CAP_SALES1.qvd]

(qvd) where Last_Version='Y' ;

TempInterval:

intervalmatch([Calendar Date])

load

[Start Date] ,

[Closure Date]

resident Table1;

Reuired output:

Start date	Closure date	[SC# SALES Closed]
10-12-2017	01--1-2018	234
20-11-2016	31-10-2018	6258

Thanks,

KIshore

Re: Interval match issue

Gopi_E — Fri, 07 Sep 2018 06:57:27 GMT

Hi Naresh,

try like this

TempInterval:

intervalmatch([SC# SALES Closed])

load

[Start Date] ,

[Closure Date]

resident Table2;

Re: Interval match issue

Anonymous — Fri, 07 Sep 2018 16:35:40 GMT

Hi Naresh,

Everything looks good with the above script, just put inner join before interval match to avoid synthetic keys and I am assuming that resident table is a typo, It should be Table2 if it's not a typo.

And one more question is that can we know the format of data in fields Calendar Date, Start Date, and Closure date. If you give those formats it would be easy for us to resolve ur issue.

If you are having a different format that dd-mm-yyyy in your source then this will not work. You should use both the above date #() for interpreting and date() for showing.

Try above and let us know. If its not working then please give us more information.

Thanks,

Sarat.K