topic Re: extended interval match in QlikView

extended interval match

deepakqlikview_123 — Sat, 28 Jun 2014 10:33:37 GMT

Hi All

Can you please give me some easy example for extended interval match just for my understanding.

Thanks in advance

Re: extended interval match

swuehl — Sat, 28 Jun 2014 10:51:55 GMT

You'll find a detailed description and samples in Henric's blog post and the referenced technical brief:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch

IntervalMatch and Slowly Changing Dimensions

And here a solution with a WHILE instead of INTERVALMATCH:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates

Re: extended interval match

deepakqlikview_123 — Sat, 28 Jun 2014 12:08:36 GMT

Hi Swehi,

Thanks for your response.

Can you please give me some simple example.

So that it will be clear for me what is basic difference between interval match and extended interval match.

Thanks

Re: extended interval match

selvakumarsr — Sat, 28 Jun 2014 12:25:12 GMT

See this example.. It may help you.. Slow changing dimension

Selva

Re: extended interval match

swuehl — Sat, 28 Jun 2014 12:43:34 GMT

The basic difference is that you are using one or more additional key fields when matching your numeric values to the intervals.

Re: extended interval match

deepakqlikview_123 — Sat, 28 Jun 2014 13:49:17 GMT

Hi Swehi,

Can you please give me some more detail.Right now i have personal addition I am not able to view QVW file provided by u.

Thanks

Re: extended interval match

swuehl — Sat, 28 Jun 2014 13:56:24 GMT

I haven't posted any QVW files, maybe you are referring to Selva's post.

Have a close look to the technical brief and the attached example files there:

IntervalMatch and Slowly Changing Dimensions

I believe Henric has PE-enabled the sample files, so you should be able to open them.

Re: extended interval match

deepakqlikview_123 — Sun, 29 Jun 2014 10:10:17 GMT

Hi Swehi/Selva,

Thanks for sharing with me such useful information.

Can you please tell me what will be the contents at UI level in SCD.

Is it based on composite key whatever we have created.

Ho w can we make the selection.

Thanks,

Re: extended interval match

deepakqlikview_123 — Mon, 30 Jun 2014 06:34:06 GMT

Hi all,

Can you please help me out in this.

what will be the contents at UI level in SCD and extended SCD.

Is it based on composite key whatever we have created.

Ho w can we make the selection.

Re: extended interval match

swuehl — Mon, 30 Jun 2014 18:48:56 GMT

Could you elaborate your problems a little bit, best by posting a small sample file?

I don't think there is much difference in using SCD compared with non-changing dimension from a UI level.

For example, if you have a sales rep that worked for different branches last year and this year, QV will automatically assign his sales correctly to the branches if you've the data model done right (e.g. using INTERVALMATCH). There is nothing special on UI side.

Probably I just don't get your issue here.