topic Match time in QlikView

Match time

Fri, 12 Nov 2010 13:14:41 GMT

hi,

i.m trying to add a categorie to this tabel:

Depending on this tabel:

The first table has all operations in a 22-7-10, the second table has the planed sessions on the same day.
I'd like to ad a field to the first table which says if the operatoin is performed within the planned session or not.

In this case all operation are within a session but sometimes not..
how can i manage to calculate this field?

thanx, regards,

david

Match time

Miguel_Angel_Baeyens — Fri, 12 Nov 2010 13:29:04 GMT

Hello David,

Check this post in regards to get the minimum and maximum values for each range. In that example, those records without a "Name" (null or empty value) should not be within the planned session. Then you can flag those fields in the load script or count for values not equal to the ranges.

FactsDatesRange: // this would go after the intervalmatch - left join tableLOAD *,If(Len(Name) = 0, 1, 0) AS OutOfRangeFlagRESIDENT FactsTable; DROP TABLE FactsTable;

Hope that helps.

Match time

Fri, 12 Nov 2010 13:50:37 GMT

hi Miguel,

i hadn't used the interval match function so i will try this option..

but i don't want to match time only, the specialism and the okkamer should also be the same...
(the example table i showed contained only OOG and OKKamer 6 but on the same day are also other specialialisms (CHI, ORT etc) and different OKKamers 1,2,3,4,5.. does intervalmatch cover this?

Regards,

david