Data modelling in between Measure and Interval Table

Anonymous — Mon, 20 Nov 2017 00:14:43 GMT

Hey folks,

I want to create a data structure that provide me a feature as below:

When I click the interval value in the dashboard, I can see the value of measure which is in same interval.

Measure	Interval1	Interval2
550	456	567
600	540	690
700	670	770

All I want to do is creating a new model that will show me the all value of intervals when I click a specific measure. What kind of changes do I need to implement in my data structure

For instance,

Measure	Interval1	Interval2
550	456	567
	540	690

%KeyInt and %Facts are foreign keys for tables. The value of intervals in Interval.Interval (Interval) and the value of measurements is inside of Measure.Measure (Measure).

Thanks in advance,

topic Data modelling in between Measure and Interval Table in QlikView

Data modelling in between Measure and Interval Table