Two questions on time

[jcharles]

1. I have a list of data containing when a TV advert is flighted on a specific day. The advert is a 30 second advert that runs anytime during that timeslot.

Date	Start Time	End Time	Channel	Programme
01/11/2013	05:00:00	05:30:00	ZZZ	Days of Our Lives
01/11/2013	10:30:00	12:30:00	XXX	Iron Man
24/11/2013	15:15:00	15:45:00	XXX	News

When the ad flights a person sms's a keyword into a number after which I get a report that looks like this:

Date	Time	Cell Number
01/11/2013	05:26:14	555 555 5555
01/11/2013	06:13:29	555 556 5577
01/11/2013	10:19:00	555 559 9988
01/11/2013	11:55:23	555 553 3322

My questions are:

I need to be able to allocate the number of sms's that come in to a specific advert. (Count the number of leads per advert). How do I do this?

How do I create a list box with time slots that can be chosen - e.g. any ad that runs between 05:00 and 10:00 - when selected in list bix then tables will give the number of ads run during that timeslot and the number of corresponding sms's that relate to that ad? (We assume sms's that come in anytime from when the ad was flighted to when the next ad is flighted on the same day belongs to that ad. When the next ad is flighted we start counting the sms's for the next ad).

[Clever_Anjos]

For question one, check your manual for IntervalMatch

For question two, check your manual for Class()

[hic]

See also http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch

HIC

[jcharles]

Thank you - It is a big help to know what to look for.

[jcharles]

Thank you - It is a big help to know what to look for. and thanks for the link

[#6]

post your sample application

[#7]

Hi Joyce,

table1:
Load Date, [Start time] , [End time] , Channel , program From Table1;

         table2:

        Load Date, Time  , Cell Number From Table2;

IntervalMatch:
IntervalMatch (Date)
Load distinct 

[Start time][End time] resident Table1;

Hope it helps...

[jcharles]

Thank you, really appreciated