Skip to main content
Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

IntervalMatch and Slowly Changing Dimensions

cancel
Showing results for 
Search instead for 
Did you mean: 
hic
Former Employee
Former Employee

IntervalMatch and Slowly Changing Dimensions

Last Update:

Jun 3, 2013 7:51:38 AM

Updated By:

hic

Created date:

Jun 3, 2013 7:51:38 AM

Attachments
  • What techniques are there to match a number with an interval?
  • How does the IntervalMatch prefix work?
  • Should I join the interval match table with the event table?
  • How do I generate an interval from a single change date?
  • What is a Slowly Changing Dimension?
  • How do I model a multi-level Slowly Changing Dimension?

These questions and others are answered in this Technical Brief.

Thank you Barry for good discussions.

See also the following blog posts

IntervalMatch

Creating a Date Interval from a Single Date

Creating Reference Dates for Intervals

Slowly Changing Dimensions

HIC


Comments
Anonymous
Not applicable

Fantastic job on this document.  Thank you.

I have a task I wish to accomplish within a Qlikview application which looks almost exactly like what this gentleman has described solving in SQL Server:

http://www.sqltreeo.com/wp/how-to-merge-combine-date-intervals-in-t-sql/

It would be like collapsing multiple dimension intervals into one unified table.  Not sure if this makes sense but the example above shows exactly what I'd like to do.  I can't picture how to code this in Qlikview.

Thanks,

JC

0 Likes
hic
Former Employee
Former Employee

Isn't this the same as the partitioning I do on page 17?

HIC

0 Likes
pgrenier
Partner - Creator III
Partner - Creator III

Excellent work! This is a well written and very clear presentation of a precious QlikView functionality that is so poorly documented in the QlikView Help (F1)!

Thanks! 🙂

0 Likes
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Excellent Work !!!

0 Likes
Anonymous
Not applicable

Exactly! 

My apology.  I realized I did not read the last section of your doc which discusses exactly what I was asking.

0 Likes
Not applicable

Very well explained, well writen post with clear and good examples in the .zip file.

This really helped me a lot to understand how to use intervalmatch!

Thank you.

JM

0 Likes
Not applicable

Comprehensive,Precise and absolutely stunning post.Must read for every Qlikview Developer. Thanks Henric.

Anonymous
Not applicable

Hi Henric,

Could you please let me know how to open this QVS files which you have attached in example?

Thanks & Regards,

Kiran Kokade

0 Likes
hic
Former Employee
Former Employee

The qvs (QlikView Script) files are plain text files that you can open with any text editor, e.g. Notepad.

Or, you can open the QlikView Script editor and do "Insert -> Script File"

HIC

0 Likes
Anonymous
Not applicable

Sorry Henric

But how should I run this example.It consist  QVS file.

When I am trying to inser using "Insert -> Script File" wizard,It is creating circular loop.

Thanks & Regards

Kiran Kokade

0 Likes
Version history
Last update:
‎2013-06-03 07:51 AM
Updated by:
Former Employee