Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anushree1
Specialist II
Specialist II

From and To Selections

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.

2 Replies
swuehl
MVP
MVP

Kushal_Chawda

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

From Date & To Date Selection Script Solution