From and To Selections

anushree1 — Fri, 08 Sep 2017 08:10:52 GMT

Hi,

I have a requirement wherein i need to have filters on Year Quarter wherein the Filters need to be split as From Year Quarter and to Year Qtr.

So the From Year Qtr Will have values like 2016Q1,2016Q2, 2016Q3, 2016Q4 and 2017Q1, whearas TO Year Qtr must have all values except the the min Year Qtr Available which would be 2016Q2, 2016Q3, 2016Q4 and 2017Q1.

I have acheived this in the script level by creating a table with all Year Qtr left joinned with All Year Quarters except the min Year Qtr available.

But this approach is very Time consuming as we need to traverse the complete table fetch the distinct Year Qtr available and then perform the logic.

Could anyone let me know if this issue could be addressed in any other way.

Re: From and To Selections

swuehl — Fri, 08 Sep 2017 08:21:13 GMT

Maybe similar to this

Subroutine to Create Data Model for From/To Date Selection

Re: From and To Selections

Kushal_Chawda — Fri, 08 Sep 2017 08:50:14 GMT

see this, create quartes in From Date & To date table

From Date & To Date Selection Script Solution

topic Re: From and To Selections in QlikView

From and To Selections

Re: From and To Selections

Re: From and To Selections