Interval match()

[#1]

Hi All

      What are the places we use IntervalMatch()......give some example...

[tresesco]

Check this blog post: IntervalMatch

[Anonymous]

Hi,

when ever we have a slowly changing dimensions in our data.in that scenarios we can use interval match function

slowly changing dimension(SCD)-means.,

If a.dimension value changes with respect to the time is called slowly changing dimension.

like Salary date.

[hemanthaanichet]

Hi Karuppasamy,

Refer this link below:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptPrefixes/Interva...

Regards

Hemanth

[Anonymous]

hi,

also fallow this example,

Interval Match Feature/Function

[rido1421]

Hi Karuppasamy

If you have a look at the two Tables below

You will see Salesman John was in the team tigers from 2016/01/01 to 2016/05/01

He then moved to team lions from 2016/05/02 to 2016/12/02

When you load this data in without doing an interval match and linking by only the SalesManID you will get an incorrect sales value for the teams as John was in two different teams within 2016.

I have put up a model with two tabs showing how loading the data normally and loading it with interval match will affect the sales value by team.

SalesMan:  

SalesManID	SalesMan	SalesTeam	From_Date	To_Date
1	John	Tigers	2016/01/01	2016/05/01
2	Paul	Lions	2016/01/01	2016/12/02
3	Peter	Sharks	2016/01/01	2016/12/02
4	Ivan	Sharks	2016/01/01	2016/12/02
5	Ralph	Cheetahs	2016/01/01	2016/12/02
1	John	Lions	2016/05/02	2016/12/02

Sales: 

Date	SalesAmount	SalesManID
2016/03/01	2580	1
2016/04/05	8564	2
2016/06/06	39	1
2016/03/09	4059	1
2016/07/08	9249	3
2016/09/07	6332	4
2016/06/06	7598	5
2016/10/11	7907	1
2016/02/03	3976	4

[#7]

Thank you Hendricks

[#8]

Thank you Henricks now only I got knowledge in Intreavelmatch)() thanks a lot

[kkkumar82]

One more example on  HR data

Beginners Task Series - Task3(Interval Match)

[rido1421]

Would you mind marking your most helpful answer as correct so as to close the item 🙂