extended interval match

[deepakqlikview_123]

Hi All

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

Thanks in advance

[swuehl]

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

[deepakqlikview_123]

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

[selvakumarsr]

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

Selva

[swuehl · Accepted solution]

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

[deepakqlikview_123]

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

[swuehl]

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.

[deepakqlikview_123]

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,

[deepakqlikview_123]

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.

[swuehl]

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.