IntervalMatch and Slowly Changing Dimensions in Qlik Analytics

[hic]

• 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 the attached Technical Brief.

See also the following blog posts:

• IntervalMatch
• Creating a Date Interval from a Single Date
• Creating Reference Dates for Intervals
• Slowly Changing Dimensions

[Anonymous]

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

[hic]

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

HIC

[pgrenier]

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]

Excellent Work !!!

[Anonymous]

Exactly! 

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

[#7]

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

[#8]

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

[Anonymous]

Hi Henric,

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

Thanks & Regards,

Kiran Kokade

[hic]

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

[Anonymous]

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