QlikView documentation and resources.
These questions and others are answered in this Technical Brief.
Thank you Barry for good discussions.
See also the following blog posts
Creating a Date Interval from a Single Date
Creating Reference Dates for Intervals
Slowly Changing Dimensions
Thanks, very helpful
Hi hic and Community,
I did some practic according the method what I found in the PDF, „Method 2: Using a While loop creating enumerable values”. Tried it with minutes instead of days but wasn’t able to implement it, there is an issue with the BridgeTable.
Thanks for your help in advance,
Event: LOAD * Inline [ Time, Event, Comment 01:01, E1, Line stop 01:06, E2, Line restart 50% 04:15, E3, Line speed 100% 08:00, E4, Start of shift 2 11:43, E5, End of production ]; Intervals: LOAD *, Recno() as IntervalID INLINE [ Start, End, Order 01:00, 01:16, A, 02:30, 07:58, B, 03:04, 10:27, C, 07:23, 11:43, D, 17:00, 18:00, E, ]; BridgeTable: LOAD Distinct * Where Exists(Time); LOAD Time((Start+(Iterno()-1)/1440)) as Time, IntervalID Resident Intervals While Time((Start+(Iterno()-1)/1440)) <= End ;
Can you please assist me on this?
Slowly Changing dimension - IntervalMatch (duplicated date problem
I used IntervalMatch for SCD but my date has been duplicated !
I'm really confused !
maybe you can try DISTINCT when you are creating the bridge table.
Excellent blog, as usual, I just went through the examples and I found that Method 1 in your example is working for half-open intervals perfectly fine. My code for intervals table is as follows:
LOAD * INLINE [
Interval_ID, Interval_Start, Interval_End, Interval_Name
1, 0, 999.99, 0-1000
2, 1000, 1999.99, 1000-2000
3, 2000, 2999.99, 2000-3000
4, 3000, 3999.99, 3000-4000
5, 4000, 4999.99, 4000-5000
6, 5000, 5999.99, 5000-6000
7, 6000, 6999.99, 6000-7000
8, 7000, 7999.99, 7000-8000
9, 8000, 8999.99, 8000-9000
10, 9000, , 9000 Above
So, I am leaving the upper-bound blank and its working fine for me. So, the limitation in the pdf - pg.no 5 - 2nd paragraph is no more. What do you say ?
links are broken after moving to new format 😞