Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
niharika
Creator II
Creator II

Set Analysis Help

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.

5 Replies
sunny_talwar

I used Interval Match, see if this works for you

niharika
Creator II
Creator II
Author

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

michielvandegoo
Specialist
Specialist

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,

Great dreamer's dreams never fulfilled, they are always transcended.
niharika
Creator II
Creator II
Author

Any other ideas?