topic Re: Interval match() in QlikView

Interval match()

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

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

Re: Interval match()

tresB — Fri, 02 Dec 2016 04:57:43 GMT

Check this blog post: IntervalMatch

Re: Interval match()

Anonymous — Fri, 02 Dec 2016 05:00:22 GMT

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.

Re: Interval match()

hemanthaanichet — Fri, 02 Dec 2016 05:06:01 GMT

Hi Karuppasamy,

Refer this link below:

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

Regards

Hemanth

Re: Interval match()

Anonymous — Fri, 02 Dec 2016 05:09:27 GMT

hi,

also fallow this example,

Interval Match Feature/Function

Re: Interval match()

rido1421 — Fri, 02 Dec 2016 06:32:41 GMT

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

Re: Interval match()

Fri, 02 Dec 2016 06:34:54 GMT

Thank you Hendricks

Re: Interval match()

Fri, 02 Dec 2016 08:33:54 GMT

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

Re: Interval match()

kkkumar82 — Fri, 02 Dec 2016 08:46:23 GMT

One more example on HR data

Beginners Task Series - Task3(Interval Match)

Re: Interval match()

rido1421 — Fri, 02 Dec 2016 11:36:40 GMT

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