Need help with an application i inherited

[#1]

Hello,

I am having an issue with an application i inherited. I am still a learner in qlikview. The application is developed already but i am not able to understand why the previous developer used a function in the script. there are basically three tables. two tables have a common key but one does not have any common key.  the developer used interval match function and left joined it to one of the table with common key.

here is the script

//1st table

campaign:

LOAD [Campaign id],

Start,

  End,

Name,

  Cost

FROM Campaign-Source-Data.xlsx (ooxml, embedded labels, table is campaign);

//2nd Table

LOAD EmailReceivedDate,

EmailOpenTime,

[Customer id],

Month,

Year,

1 As Email,

Clicked

FROM Campaign-Source-Data.xlsx (ooxml, embedded labels, table is clicks);

//i am trying to learn why he did this?

inner Join

IntervalMatch(EmailOpenTime)

LOAD

Start,

End

Resident campaign;

Left Join

LOAD

[Campaign id],

     Start,

     End,

     Name as [Campaign Name],

     Cost as [Campaign Cost]

   Resident campaign;

DROP Table campaign;

customers:

LOAD Customer as [Customer id],

Age,

Country,

Gender

FROM Campaign-Source-Data.xlsx

(ooxml, embedded labels, table is customers);

I would really appreciate any help with this.

Thank you,

SMQ

[#2]

I am trying to understand why he did this in the script

inner Join

IntervalMatch(EmailOpenTime)

LOAD

Start,

End

Resident campaign;

Left Join

LOAD

[Campaign id],

     Start,

     End,

     Name as [Campaign Name],

     Cost as [Campaign Cost]

   Resident campaign;

DROP Table campaign;

[tresesco]

It would be even tough for people here to say why it was done so without knowing your data and business logic. Ideally, when you take over a project/dashboard the KT would be the key. If you were not KTed properly then it's a mess. At this point, I can ask you to read about the business logic and data structure first and then may be learn qv: IntervalMatch ‒ QlikView and Join ‒ QlikView from help/manuals.

[jonathandienst]

The code is is associating a campaign (with a start and end date) with the email information (with a sent date in the interval between the campaign start and end date). But as Tresesco said, its hard to be more specific than that.

[arvind_patil]

Hi Syed ,

Please look into help about interval match so will get basic idea of it.

Thanks,

Arvind Patil

[arvind_patil]

Also look into attach example:

Thanks,

Arvind Patil