topic Re: Two questions on time in QlikView

Two questions on time

jcharles — Wed, 27 Nov 2013 08:35:56 GMT

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).

Re: Two questions on time

Clever_Anjos — Thu, 28 Nov 2013 18:25:34 GMT

For question one, check your manual for IntervalMatch

For question two, check your manual for Class()

Re: Two questions on time

hic — Thu, 28 Nov 2013 19:02:37 GMT

HIC

Re: Two questions on time

jcharles — Fri, 29 Nov 2013 06:21:58 GMT

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

Re: Two questions on time

jcharles — Fri, 29 Nov 2013 06:22:35 GMT

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

Re: Two questions on time

Fri, 29 Nov 2013 06:40:57 GMT

post your sample application

Re: Two questions on time

Fri, 29 Nov 2013 06:50:33 GMT

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...

Re: Two questions on time

jcharles — Tue, 03 Dec 2013 09:39:02 GMT

Thank you, really appreciated