Datamodel optimization - IntervalMatch from to

pamaxeed — Wed, 11 Jun 2014 19:08:43 GMT

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

Re: Datamodel optimization - IntervalMatch from to

Wed, 11 Jun 2014 19:12:22 GMT

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

Synthetic keys are expected with Interval Match

topic Datamodel optimization - IntervalMatch from to in QlikView

Datamodel optimization - IntervalMatch from to

Re: Datamodel optimization - IntervalMatch from to