topic Re: Set Analysis Help in QlikView

Set Analysis Help

Anonymous — Mon, 25 Apr 2016 11:33:06 GMT

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.

Re: Set Analysis Help

sunny_talwar — Mon, 25 Apr 2016 11:37:14 GMT

I used Interval Match, see if this works for you

Re: Set Analysis Help

Anonymous — Mon, 25 Apr 2016 11:39:26 GMT

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

Re: Set Analysis Help

Michiel_QV_Fan — Mon, 25 Apr 2016 11:39:31 GMT

Use intervalmatch to solve this, not a link table.

Re: Set Analysis Help

PrashantSangle — Mon, 25 Apr 2016 11:39:52 GMT

Hi,

I think IntervalMatch() will resolve your issue.

Check in help menu about IntervalMatch()

Kind regards,

Re: Set Analysis Help

Anonymous — Tue, 26 Apr 2016 10:06:39 GMT

Any other ideas?