Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

IntervalMatch and Slowly Changing Dimensions

Employee
Employee

IntervalMatch and Slowly Changing Dimensions

  • 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
jcooney1
New Contributor III

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

Employee
Employee

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

HIC

pgrenier
Contributor 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! :-)

phaneendra_kunc
Valued Contributor III

Excellent Work !!!

jcooney1
New Contributor III

Exactly! 

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

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

Not applicable

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

kirankkk
Contributor

Hi Henric,

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

Thanks & Regards,

Kiran Kokade

Employee
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

kirankkk
Contributor

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

Version history
Revision #:
1 of 1
Last update:
‎06-03-2013 07:51 AM
Updated by:
Employee