Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use advanced expressions in filter

Hi all.

I would like to know if it is possible to use complex/advanced expressions to use in filter object.

Example:

I have a date column (birth date). If I use it in a filter I can choose among all the possible values or I can write something like

>1990-01-01

It would select all values greater than this date. I would like to write (for example) something like:

>1990-01-01 and <2015-01-01

I would like the users to have this power.

Thanks in advance

Please see picture below with one example

Sample2.jpg

1 Solution

Accepted Solutions
MarcoWedel

Hi,

you can search for intervals like:

>24/11/2014<30/11/2014


without "and"


hope this helps


regards


Marco

View solution in original post

3 Replies
MarcoWedel

Hi,

you can search for intervals like:

>24/11/2014<30/11/2014


without "and"


hope this helps


regards


Marco

MarcoWedel

QlikCommunity_Thread_182732_Pic1.JPG

QlikCommunity_Thread_182732_Pic2.JPG

regards

Marco

Not applicable
Author

Thanks a lot.

I've also tried the following:

Field_name>200 AND Field_name<300 and it worked as well.