Set Analysis Help

[Anonymous]

Hi All,

I have two Tables, Qty and Range. In Qty Table, there is a Date column and in Range Table has Startdate and Enddate. Calendar is created using Date from Qty table and Start date from Range Table.

In a straight Table, I am displaying the Limit between Start date and Enddate as below.

Both the above records should be coming up even when the section is Apr-2016. But as the Calendar date is based on Start date, the record is not coming when Apr-2016 is selected. There cannot be a any change in the Script.Whatever the change is should be done at UI only.

Please help.

Attaching the qvw.

[sunny_talwar]

I used Interval Match, see if this works for you

[Anonymous]

Thanks Sunny for the quick Response. But I cannot change the script. Whatever the change is should be at UI only not at Script level

[Michiel_QV_Fan]

Use intervalmatch to solve this, not a link table.

[PrashantSangle]

Hi,

I think IntervalMatch() will resolve your issue.

Check in help menu about IntervalMatch()

Kind regards,

[Anonymous]

Any other ideas?