Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Need help with an application i inherited

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

5 Replies
Not applicable

Re: Need help with an application i inherited

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;

MVP
MVP

Re: Need help with an application i inherited

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.

MVP
MVP

Re: Need help with an application i inherited

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
Valued Contributor II

Re: Need help with an application i inherited

Hi Syed ,

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

Thanks,

Arvind Patil

arvind_patil
Valued Contributor II

Re: Need help with an application i inherited

Also look into attach example:

Thanks,

Arvind Patil