Datamodel optimization - IntervalMatch from to

[pamaxeed]

Hi,

i would like to know if there is a way to optimize the following datamodel, which contains a synthetic key.

The best practise of qlikview tell us to avoid synthetic keys and eliminate them if they appears in our datamodel.

But in my use case i do not know if there is the need and if it is possible to avoid it.

In my dummy application the 3 important fields are CODE, FROM and TO.

And i am using the interval function to check if a selected date is between the FROM and TO range.

Here the snippet of the script:

IntervalMatch (DateList) load From ,To Resident DateLink;

I created a DateLink table which contains the Key and the From and To fields of each table involved in my model and dropped then this fields from the corresponding tables.

As result, my model looks like this:

Just for my curiosity is there a way to avoid the synthetic key in my usecase scenario?

Thanks,

Patric

[#2 · Accepted solution]

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

Synthetic keys are expected with Interval Match