Qlik Community

QlikView Documents

Documents for QlikView related information.

IntervalMatch and Slowly Changing Dimensions

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

0 Likes

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

HIC

0 Likes
Partner
Partner

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
Partner
Partner

Excellent Work !!!

0 Likes
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.

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.

0 Likes
kirankkk
Contributor II

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

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
kirankkk
Contributor II

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
Revision #:
1 of 1
Last update:
‎2013-06-03 07:51 AM
Updated by: