Filter expression

learner

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

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

if i understood your purpose correctly

learner

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

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

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

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

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