Dynamic Filters (Range)

[dingo]

Hello,

I m workin on a task where I need to allow the program numbers to be entered by users dynamically. i.e, Users should enter BETWEEN 19 AND 21 OR BETWEEN 27 AND 30 OR BETWEEN 32 and 35 and I should take those numbers and display results.

For Ex, In the derived table SQL, 
SELECT * FROM TABLE WHERE 

age BETWEEN 19 AND 21 

OR BETWEEN 27 AND 30

OR BETWEEN 32 and 35 ;

How do I achieve this in Looker? I cant use Templated filters  since they are only for logical results (i.e, age =’1’  or age IN (1,2)). Can I use parameters in SQL derived table?

Can someone please help? Thanks in Advance.