Filter expression

learner · 2009-06-04

how can I set in filter
from (1-10) but not (4, 6 and 7) and (15-19) but not 17?

i tried the following:
1..10 <> 4 <>6 <>7 | 15..19 <> 17

Says..incorrect Expresion!

( I dont have a manual with me now)

Belias · 2009-06-04

1..3|5|8..10|15|16|18|19

if i understood your purpose correctly

learner · 2009-06-04

Thanks, but i want to use <> (not expression)
The numbers given are just example..i have a long list of the code and each code is 14 characters.
How can I sue NOT expression here?

Belias · 2009-06-04

I answered to your original question, if your purpose is to use <> operator, then you can try with this:
(i'm not 100% sure it works, you should try it)
1..10&<>4&<>6&<>7|15..19&<>17

kriki · 2009-06-04

The Filtergroup-solution is the most beautiful one and probably the easiest one too.
With filtergroups you can put different filters on the same field. It is like putting an AND between the different filters.

SETFILTER("The Field",'1..10|15..19');
FILTERGROUP(10);
SETFILTER("The Field",'<>%1',4);
FILTERGROUP(11);
SETFILTER("The Field",'<>%1',6);
FILTERGROUP(12);
SETFILTER("The Field",'<>%1',7);
FILTERGROUP(13);
SETFILTER("The Field",'<>%1',17);

FILTERGROUP(0);

learner · 2009-06-04

Belias wrote:

I answered to your original question, if your purpose is to use <> operator, then you can try with this:
(i'm not 100% sure it works, you should try it)
1..10&<>4&<>6&<>7|15..19&<>17

Thanks Much it worked..

kriki wrote:

SETFILTER("The Field",'1..10|15..19');
FILTERGROUP(10);
SETFILTER("The Field",'<>%1',4);
FILTERGROUP(11);
SETFILTER("The Field",'<>%1',6);
FILTERGROUP(12);
SETFILTER("The Field",'<>%1',7);
FILTERGROUP(13);
SETFILTER("The Field",'<>%1',17);

FILTERGROUP(0);

How/Where do I set this when I am trying to filter one of the dimensions for Analysis by dimesion?

kriki · 2009-06-04

I thought it was programmatically. I didn't think about the fact that it was for manually setting filters.

Filter expression

Comments

Categories