Skip to main content
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.