topic Re: IntervallMatch in QlikView

IntervallMatch

thanstad — Sat, 23 Nov 2013 09:08:38 GMT

Based on daily data from a TV distributor, they offer people to rent movies. I have a discrete table with a Date_Time stamp when a movie is rented. The discrete table does not have a start and end time for rental, but I was thinking about generate a INLINE table with four different timeintervalls. I have not succeded on this, Can anyone give me a hint how to cope with this. The onle exmples I have seen is based on Start and End time in the transactionsdata.

Tormod Hanstad

Re: IntervallMatch

swuehl — Sat, 23 Nov 2013 12:38:20 GMT

Sorry, I don't understand what you want to do here.

You have a transaction table with purchase timestamps, ok.

How do you want to determine the length of the rental from that? Are there any conditions they sign?

If you know the allowed rental period, you can just create a new field for the end date adding the rental period to the start timestamp:

Let vRentalPeriod = 2.5; // days

LOAD Xstream_Purchase__User_ID,

Xstream_Purchase__Date,

Xstream_Purchase__Time,

Xstream_Purchase__Movie_ID,

timestamp(Xstream_Purchase__Date+Xstream_Purchase__Time) as PurchaseDateTime,

timestamp(Xstream_Purchase__Date+Xstream_Purchase__Time+$(vRentalPeriod)) as RentalEndDateTime

FROM

[IntervallMatch.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: IntervallMatch

thanstad — Sun, 24 Nov 2013 07:40:03 GMT

Thanks for reply and suggestion. Well I was thinking about to split the Date/Time into groups Morning,Afternoon, Night etc. But I see now that an loose table generated by inline with this groups and use this one to make this split.

Split_hrs:

LOAD INLINE[Group,Description

0,Morning

1,Afternoon

2,Evening

3,Night

];

Tormod