I am trying to use the IntervalMatch() function - the advanced version with keyfields to compare - but it isn't working - well, QlikView is generating the table, but it has 0 records.
What I do is this:
- First I load a master_calendar from a qvs_file that has a field called %Datum.
- Then I load a table with intervals and some more keyfields and some more data from a qvd (I concatenate the three keyfields into one)
=> Now I would like to use that function to have the right interval (and keyfields) for every day.
=> So I write
IntervalMatch (%Datum, Key)
LOAD
Interval_start,
Interval_end,
Key
RESIDENT ... ;
I realized that field %Datum is already formatted while both Interval_start and Interval_end are in numeric format - I have already replaced that. Still the resulting table has 0 records. The maximum Interval_end also is Today().
Ah, I see. If I specify any keyfields, those would have to be in my master_calendar - which they are not of course, they are specific to that history_table.
So I have to first split up all intervals - I can use DISTINCT there avoid splitting the very same interval several times - and then I have to join that.
Let's see ...
p.S.: Where does the DISTINCT keyword have to go then? In the IntervalMatch_LOAD?
Ah, I see. If I specify any keyfields, those would have to be in my master_calendar - which they are not of course, they are specific to that history_table.
So I have to first split up all intervals - I can use DISTINCT there avoid splitting the very same interval several times - and then I have to join that.
Let's see ...
p.S.: Where does the DISTINCT keyword have to go then? In the IntervalMatch_LOAD?
